Search results

How do you set up access database to run from an icon on the desktop rahter than allowing user to go in using access? Thanks in advance... ...TheB

Thanks Mile!!! Worked great!!!

Tim, Thanks again for the help but I was able to discover what I needed. You need to surround the date with # signs to tell access the literal is to be treated as a date. Again thanks for all your help. ...Bruce

Tim, Once again thanks for your help. However. my query does not seem to be working. Let me explain further... This is my syntax coded in VB to generate my where clause for the report I am working on. sWhere = sWhere & " AND ([AD_SALES_DATE] BETWEEN " & CDate(Int(BegSalesDate)) & " AND " &...

Tim, Thanks for the reply. Took your advice and it worked. It did strip off the time. My next problem is that the AD_SALES_DATE is defined as Short Date. with the Int function I have converted the BegSalesDate/EndSalesDate to Integer. Now I am comparing type date to type integer. How...

Hi, I am dynamically building a query based on user choices. Two choices within the query are to pick a beginning date and an ending date. I am using the Microsoft date/time picker for both. When I debug the form to see the query it is showing time as well as date. How can I strip off time...

Sorry Rich, Still learning how to use this forum. Thanks for the tip. ...TheB

Sorry Rich, Still learning how to use this forum. Thanks for the tip. ...TheB

Hi, I am from Canada. I wish to have my user enter dates as "dd/mm/yyyy". I am having difficulty setting up aninput date mask on a form to appear as "dd/mm/yyyy" so that user will know how to enter the date. How would I set up the mask so that user actually sees the "dd/mm/yyyy" in the...

AncientOne, Here are my answers. When is this code triggered? It is triggered on a preview report command button on form. is the form you are validating the active form at the time? I believe so. Is the form visible? Yes. Is the control enabled? Yes, if you are referring to fiield I want...

Rich, Sorry. Was not sure of the forum etiquette. Just was not sure if I had posted it to the right forum. ...TheB

Dave, Thanks for the response. However I tried that and when I run the form the input mask looks like this. __/__/___ I want it to like this. dd/mm/yyyy What am I missing?? Thanks in advance. ...Bruce

How do you set up date field on form such taht it will appear as dd/mm/yyyy for easy entry by user. I would also like it to be stored in database as ddmmyyyy. Pardon my ignorance here but I am quite new to VB and still learning. Thanks in advance. ...Bruce

Hi, I have built a form for a report. I am in process of validating the fields on the form before generating my report. I have included a snippet of the code so you can see what I am trying to do. If (txtIssue <> "") Then sWhere = sWhere & " AND [AD_MAGAZINE_ISSUE] = " &...

Hi, I have built a form for a report. I am in process of validating the fields on the form before generating my report. I have included a snippet of the code so you can see what I am trying to do. If (txtIssue <> "") Then sWhere = sWhere & " AND [AD_MAGAZINE_ISSUE] = " & txtIssue...

One more question Jon, Thanks for your help. However, I am confused on your selections for the "Show" and "Criteria" options. Can you elaborate as to why you would uncheck the Show option? Also how and why would I set the Criteria to false. Forgive my ignoraance here but I am quite new to...

Thank you Rob, Thanks so much for your suggestions. I will give them a try. You have been most helpful. Have a great day. ...TheB(aka Bruce):D

Answer to your question Hi Rob, Thanks for getting back to me. In answer to yuor question I could be doing a selection on all the criteria but my guess is most of the time it will not not be. However, like I said there is a chance it could be all. Look forward to your reply. ...TheB

I have a query for which I use to produce a report. All my form fields can be populated to filter data in the report. Problem I am having is user can select only one field for which they enter specific data and the rest would not. How do I set up my Criteria in the query such that if they...

I have a table where one of the fields is defined a 'Long Integer'. The display control is 'Combo Box'. I am storing in this field a primary key from another table yet I am displaying a more descriptive field in the combo box. When I go into datasheet view for the table it seems to be storing...