Topic profile page for Empty Fields.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Empty Fields.
Topic "Empty fields" was discussed 736 times on 262 sites in last 3 months
Started 3 days, 12 hours ago (2009-11-12 17:46:00)
by jeshra279
Hi, I have an array, x = {10,20,30,"",""). I want the length of this array with non-empty fields, i.e. 3 instead of 5. Also, I want to store the entries without Null in another array. How to implement this in VB? thanks
Started 4 days, 9 hours ago (2009-11-11 20:26:00)
by Mike Sabino
I am new to Access, Im using 2007. I am building a data entry form that requires people to enter a score. It is a number field, 0 through 3, using a combo box. I set the default value to 3, but have "#;#;0;"NA"" input in the Format property, under the format tab. So it will display default of "NA". I was hoping this would give me a default value of 3 but still display "NA" but instead ...
Started 4 days, 18 hours ago (2009-11-11 12:00:00)
by Mike Sabino
I am new to Access, Im using 2007. I am building a data entry form that requires people to enter a score. It is a number field, 0 through 3, using a combo box. I set the default value to 3, but have "#;#;0;"NA"" input in the Format property, under the format tab. So it will display default of "NA". I was hoping this would give me a default ...
Started 5 days, 9 hours ago (2009-11-10 20:53:00)
by Thatch
copy non empty fields. Hey folks. I need a bit of help here if possible. I tried to do a search on this site but the search function kept throwing an error, so I hope this isn't an often repeated question. I have a worksheet from a survey that has 'a lot' of columns (D2:GU424)but for each row there is only one entry (D2-GU2 will ...
Started 6 days, 5 hours ago (2009-11-10 01:16:00)
by thehikingfool
What am I doing wrong here? Here is the SQL: TRANSFORM Sum(Query3SalesConvert.SALES) AS SumOfSALES1 SELECT Query3SalesConvert.MANUFACTURERNAME, Query3SalesConvert.CREATETERRITORYID, Sum(Query3SalesConvert.SALES) AS SumOfSALES FROM Query3SalesConvert WHERE ((Year([ENTRYDATE])=Year(Date()))) GROUP BY Query3SalesConvert.MANUFACTURERNAME, Query3SalesConvert.CREATETERRITORYID PIVOT ...
Started 6 days, 14 hours ago (2009-11-09 16:15:00)
by thehikingfool
What am I doing wrong here? Here is the SQL: TRANSFORM Sum(Query3SalesConvert.SALES) AS SumOfSALES1 SELECT Query3SalesConvert.MANUFACTURERNAME, Query3SalesConvert.CREATETERRITORYID, Sum(Query3SalesConvert.SALES) AS SumOfSALES FROM Query3SalesConvert WHERE ((Year([ENTRYDATE])=Year(Date()))) GROUP BY ...
Started 1 week ago (2009-11-08 22:25:00)
by nathan2k10
I have an HIT, which the user needs to fill some free text in a textbox,what I want to do is NOT to allow him to leave it empty,which means,if he presses 'Submit' and one of the textboxes was left blank,he wont be able to submit... any idea? thanks in advance.
Started 2 weeks, 4 days ago (2009-10-28 11:14:00)
by lg
I have a table with members and pharmacies. If it is a pharmacy the L_name field is blank. I am running a query and want to know how many pharmacies I have without the members. If I put (" ") in the L_name field and ask for F_name and platform etc I don't get any results. What is another way I can pull only if there is something in ...
Started 2 weeks, 5 days ago (2009-10-27 11:12:00)
by grossgermany
Hi suppose I have a csv file like this Code: count,1977,1978,1979 usa, , , blue japan, red, yellow,green india, , yellow,blue china, blue, yellow, green I want the output to be(replace everything, including empty data, with the most recent data): Code: count,1977,1978,1979 usa, blue, blue, blue japan, green, green,green india, ...
Started 1 month, 1 week ago (2009-10-09 12:20:00)
by Philippe G
Hello, I install Log and Trace Analyzer for Autonomic Computing on an ubuntu by sudoing. I also tested under windows XP. I launch LTA by sudoing. When I import some CBE log (it is said valid with XSD by firefox) and I try to modify printed fields, I don't see the ExtendedDataElement field. This bug occures as well under linux as under windows. Moreover, on linux, when I go to ...
Started 3 days, 7 hours ago (2009-11-12 22:47:00)
by MikeMarq
Assuming you have a variable that holds how many items are in the array you can use the redim preserve commands. redim preserve yourarray(number_of_items) One warning though. Don't overuse this command because internally it creates a new array and copies all of the contents to the new array so if you call this too many times with large arrays it can make your program slow. Also if you ...
Started 5 days, 5 hours ago (2009-11-11 01:20:00)
by Thatch
Re: copy non empty fields. Brilliant Aladin. I really appreciate the quick help. I'd like to say I was almost there with my solution, sadly I was not. Thanks again,
Started 5 days, 11 hours ago (2009-11-10 19:07:00)
by thehikingfool external usenet poster
Sorry, this is a duplicate post. Original post can be followed under 'Crosstab returns blank fields' "vanderghast" wrote: If your regional setting is not in English, the 3 letters month names may differ than the ones you supplied. If there is not data for a given month for the current year (ex: no data for December, yet), then that column will be entirely blank, since there ...
Started 5 days, 20 hours ago (2009-11-10 10:06:00)
by thehikingfool
Sorry, this is a duplicate post. Original post can be followed under 'Crosstab returns blank fields' "vanderghast" wrote: > If your regional setting is not in English, the 3 letters month names may > differ than the ones you supplied. > > If there is not data for a given month for the current year (ex: no data for...
Started 1 week, 1 day ago (2009-11-07 08:58:00)
by Pedichi
( Yes that will happen if you print your invoice from an estimate or a sales order and the fields have not been turned on in the estimate or sales order. You can turn them on in templates by pulling up the estimate / sales order template and checking on the field to have it show when you open them. After that is done the field will be automatically entered from the customer file both...
Started 4 days, 11 hours ago (2009-11-11 18:48:00)
by John W. Vinson
On Wed, 11 Nov 2009 04:02:01 -0800, nicolam1980 wrote: Hi - this thread has solved a problem I was also having but am wanting to also take it one stage further. Once either field has been selected I then have a series of additional checkboxes that need to be populated. How can I prompt the user to ensure these are populated correctly and not left blank upon saving/exiting the ...
