Recent content by TheB

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...