Search results

Maybe I can do that tommorrow, report is a summary of lots of data. I would need to create several records for each report.

I dont want to share the data I have. I don't have time to make some dummy data. I can post it without the data.

I can't post a sample db.

I'm trying to edit this code again to add another dropdown box(cboTechnician) that will query my report further. The drop down will query field [Name] which is names of technicians for the reports. I used ISnull to test that something is selected for the combobox. This the is the code that I...

Workdays would include holidays. Mon -Friday would be workdays. December has 23 workdays.

I have some dropdown buttons where you can select a month and year and then it opens up a report for that month and year. In the report I want it to automatically calculate the number of workdays (weekdays) in that month that was selected. I know in excel there is the EOMonth formula you can...

I have 3 dropdown boxes that filters a list for me on a form. I want the selection of the dropdown box to be saved for the form, for when a user navigates off the form and comes back again to the same form. When the User navigates to a form again, I want there previous selections in the dropdown...

It works!

Yes, I want to be able to see both file types. I will try that.

My csv file= .csv, I also put a .txt file in there and that isn't showing up. Dialog box is still filtering only .xls or xlsx files

It is still filtering only excel files. I have attached a picture.

the Excel files are showing up, but the CSV files are not showing up. I can try putting a different CSV file in the folder.

I have a form where you click a button then it opens a windows filepicker dialog box. I want the dialog box to show Excel files and CSV files in the filepicker. Right now only the excel files are showing up in the dialog box. I even tried converting the CSV file to excel file and they still...

I got it now! Thanks everyone!

I'm not sure how to find the UNC path?

I have a front end and backend database with userid and logins. I have the backend tables saved on the network shared drive. I have a front end version that will connect to the backend. The pathway to the shared folders is different for different users. When I link the backend files to front...

I was able to get the forms to do what I want with this code. I wanted a way to enter in the total hours at end of the month for all the current employees at the same time on one form, without having to look up the current employees names or select them. I wanted the name selection to be dynamic...

If I can't make the selection dynamic I can just let the user select the names. I wanted to make it more automatic and less room for errors from the user. I know I can make it so that each employee name drop down box will be different.

I decided just to do an unbound form. I have 6 current employees I will be tracking. I created 8 unbound employees name drop down boxes. I want each dropdown box to default to a different employee name from my current employees query. I want it be dynamic also. If one employee gets taken off of...

I'm trying to make it so everything is automatic. I want to be able to make this database and be done with any editing and then my supervisor doesn't need me to do anything with it. The only thing will be supervisor adding the hours every month. I will make a page where the supervisor can change...