Search results for query: *

Thanks Eupher....works great and good suggestions. Actually, as a novice, I make a lot of poor choices in field names, etc. I have renamed the fields and unbound the form as well. Normally, I would use a query but in this case, because I am retrieving data from multiple tables, I decided on the...

Hello All, I am trying to extract data from a table bound to a form, peform some simple math on the data, and, display the results in a text box. I am currently using the DLookup function for selecting table cells but would like to specify name in the DLookup or learn another method for...

Hello Programmers, I have been working on this last problem for my database for some time. There have been many helpful posts but I am missing a concept I believe. My database main form has txtStartDate and txtEndDate text boxes. It also has a command button to run a query and preview a report...

Hello again ZmrAbdulla, You are correct. The first pop up form is headed with "Enter Parameter Value" followed by [Forms]![frmGroup Report Form]![txtStartDate]. The second pop up form is the same heading followed by [Forms]![frmGroup Report Form]![txtEndDate]. That is the crux of...

Thank you ZmrAbdullah. I followed your directions exactly and the query sort of works. It does not extract (use) the dates in my form's text boxes but instead pops up forms for the user to input the dates. What am I missing here? I do understand the criteria statement logically but the query...

Hi Righty, I have seen this many times and more than seventy percent of the time it has been a hardware problem. I suggest you disconnect everything not needed, sound cards, ide devices including cd/dvd drives, etc. Boot the system with only fdd, hdd, ram and moniter/agp. If it doesn't cycle...

Hi Programmers, As promised, I got my bonus for my database design! I will receive it in July and make a donation to the site. Thank you all for your assistance. You folks are awesome. A new question: I'm very close to solving this but it isn't working: Have a form with txtStartDate and...

Hello programmers et al, Recently a asked a question here (thread #702-553655) and got some great answers. For a novice programmer (hardware engineer) this programming stuff is challanging/but fun! My text box clearing code clears the text boxes but requires I SetFocus on each text box first...

Hello, My first database form uses a "clear" command button to clear text boxes, etc. VB6 code for this is txtName.txt = "" Is it the same in VBA for access? Also, how would you write a line of code to clear a combo box? Thank you in advance, Bruce