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

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

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

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

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

Hi there, Forgive me but I am quite new to Access. I was hoping I could get some direction. I wish to build a dynamic report based on a table. My intention is to have the user enter information for each field on a record. For example, if wants report for a specific Sales Rep for a specific...

Hi there, I am currently in process of building Access database for a friends business. I was hoping to create an MDE file for him to use as I wanted it to be executed via a icon on his desktop rahter than going into Access. I thought I could achieve this with an MDE executable file. However...