Recent content by brow1726

FYI Problem SOLVED!!!!!!! Thank you so much for your help!!!!

I keep getting a runtime 3044 error. Invalid path. any thoughts?

If im on a network and it would be transefering to a share drive should this still work? For some reason I keep getting an error and Im unsure why. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "TimeOffTracking", "\\Share-MyName\C_Baseball_Groups\Daily\All_Person_Folder\MJB...

I am trying to export the data to a specific tab in a spreadsheet, that I configured to create a report on the next tab.

Fixed!!! Thanks All!!

I have a module but I am unsure if it is completly correct. Dim rst As DAO.Recordset Dim ApXL As Object Dim xlWBk As Object Dim xlWSh As Object Dim fld As DAO.Field Dim strPath As String Const xlCenter As Long = -4108 Const xlBottom As Long = -4107 On Error...

The line highlighted in red is where I am getting my error. Not sure why?:banghead: It's Runtime error 3265

I am trying to pull multiple fields from a ListBox to create individual records. I keep getting the runtime Error. Here is my code: Private Sub Command30_Click() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim ctl As...

So I decided to go with a list box to make it an easier process and I am having trouble trying to append the query to the table to create a single record it seems to keep multiplying the new record to double what in the database. Anyone have any Ideas?

OK well thats for your help I may re-evaluate and go with a list box instead.

Here is a stripped down version I used names of cartoon characters. The employee field is changeable as well as the employer field is not neccesary I was just using it because I thought it would be nice to have but I dont think that dlookup will work with a check box set anyways. All other...

It has an employee field, date, type of PTO, Hours Used, it has a button that runs an append query to a seperate table holding the records. At the bottom I plan to put check boxes with names attached to them. I would like to use these text boxes to sub for the employee box so say 10 people...

I have a entry form attached to a table by an append query. I have data pertaining to the certain date, amount of time taken, etc. What I would like to do is have the ability to check boxes at the bottom to sub for the employee field so I can create multiple records at one given time.

Ok thanks!! So how would I go about getting the checked boxes to substitute the employee field of the record?

Would I be able to use them to substitute a certain field in the form and still use the other data in the form for those people? Other fields include date, type of time off, amount taken, etc.