Search results

I have a database in which when it opens the main form loads and there is an On Load event for that form. It will look at the tables and for each table that doesn't start with "MSys", "~", "tbl" and "contact". This will pull the tables I need and store the names into an array. I then loop...

I hate a field that displays a date on a form. I set the conditional formatting to be Value is Between Date() and Date() + 14 It would only apply the formatting for dates that were equal to the date and +5 days. I then tried Between Now() and Now() + 14 Same results I then tried Between...

I have a listbox set to Multiselect property of Simple. The listbox is populated by using a table. There are 4 columns in the listbox 1 3/23/2014 4/5/2014 2014 2 4/6/2014 4/19/2014 2014 3 4/20/2014 5/3/2014 2014 The columns are PayPeriod, StartDate, EndDate...

I can't seem to find the answer to this. I saw a thread on here but it lead to a dead end. What I am trying to accomplish is the following: I have a database and one of the functions is to track the purchase of fuel. Part of purchasing fuel is registering what the current odometer reads...

I have photos stored in a folder on a drive. I have referenced them before in a simple picture viewer I created in a form. I create the file name by referencing the values of a list box on the field. Example: The list box has piid.2005.001 and image name is 2 filename = C:\Temp\" & pidd & "\" &...

I have a query which returns a list of reports I have created this session. I want a button that when I click it runs the query and then stores the results into a variable. I looked online and found a pretty good connection code and loop code to get the data but I'm having a hard time...

I have a database that handles schedules for workers and the projects they are on There is a personnel table which contains: Person / project / start date / end date / duration And there is a project table which contains: project / client / start date / end date / duration I have a query that...

I have a report. In this report I have a start date and an end date. I also have a date that is going to be checked. The report checks to see if the date the user entered on a different form is between the start and end date of an individual. if it is, a txt box at the end of the line will...

I have a report that shows a Start Date and an End Date. I also have a control that shows a date which I'm wanting to check. I tried the conditional formatting to create something that says When this date is greater than start date and less than end date I want the cell to be Red. >[Start...