Search results

I am also using this formula and I have a quick question. After I run it, the table is loaded, but comes up empty... does anyone know why this would occur?? Thank you.

Hey all, I am working on this database and I was wondering how to 1) Browse to find the spreadsheet I want to import 2) Import this spreadsheet through the same form that I browsed for it 3) Map the column titles to the table already created Any help is appreciated. Thanks!

Works! Thanks again pbaldy!

Is there a way for my populated table start at 1, but only fill in the salary from 10 and on?

It works! Thanks pbaldy.

@pbaldy: How do I make "9" work in that situation? As far as WkStart, I was using DCount because I was not sure how to autopopulate the table with consecutive numbers. And then how would I change GrSalary to work in this instance? @dcb: I am having problems with the "9" and autopopulating the...

Hey I have been looking through the forums, but I have not found my specific code. What I am trying to do is based on a length of time, say 24 weeks, I want a table to be populated with a count of 24 weeks, but this count will start at week 9. So it would count week 9 through week 33. And then...

Hey all, I am trying to create a report and I need to use a chart that MS Access does not have, but MS Excel does have. Is there anyway to get charts from MS Excel into Access? Or does anyone know of any website where I could download charts? Thanks!

Nevermind - I just changed the 1 to a 4... in DateAdd()

Another question though - how would I be able to make is so that the dates only populate once every 4 days? Like 5/1/09, 5/5/09, 5/9/09, 5/13/09 .... 5/29/09 Thanks a lot! Not sure how I'd be able to do this without your help! I'll play with it in the mean time.

That solved the problem. Thanks again Paul!

Private Sub Command5_Click() Dim dteStart As Date Dim dteEnd As Date Dim stDocName As String Dim rsReser As DAO.Recordset On Error GoTo Err_Command5_Click CurrentDb.Execute "DELETE * FROM tblReportDate" Set rsReser = CurrentDb.OpenRecordset("tblReportDate", dbOpenDynaset, dbSeeChanges)...

I apologize - I tried to edit it and I moved some stuff around. I am still learning how to use Visual Basic and I thought this was the correct order. I will rearrange and repost..

Private Sub Command5_Click() Dim dteStart As Date Dim dteEnd As Date Dim stDocName As String Dim rsReser As DAO.Recordset On Error GoTo Err_Command5_Click CurrentDb.Execute "DELETE * FROM tblReportDate" Set rsReser = CurrentDb.OpenRecordset("tblReportDate"...

Private Sub Command5_Click() Dim dteStart As Date Dim dteEnd As Date Dim stDocName As String Dim rsReser As DAO.Recordset On Error GoTo Err_Command5_Click CurrentDb.Execute "DELETE * FROM tblReportDate" Set rsReser = CurrentDb.OpenRecordset("tblReportDate"...

Okay I am getting an error with my sub not being defined. And thank you for your patience: Private Sub Command5_Click() On Error GoTo Err_Command5_Click Dim dteStart As Date Dim dteEnd As Date Dim stDocName As String Dim rsReser As DAO.Recordset CurrentDb.Execute...

I meant to say: " cannot find the field "l" "

Okay I changed it to this: Private Sub Command5_Click() On Error GoTo Err_Command5_Click CurrentDb.Execute "DELETE ReportDay FROM tblReportDate" Dim rsReser As DAO.Recordset Set rsReser = CurrentDb.OpenRecordset("tblReportDate", dbOpenDynaset, dbSeeChanges) Do While...

Alright: Private Sub Command5_Click() On Error GoTo Err_Command5_Click CurrentDb.Execute "DELETE * FROM tblRecordDate" Dim rsReser As DAO.Recordset Set rsReser = CurrentDb.OpenRecordset("tblRecordDate", dbOpenDynaset, dbSeeChanges) Do While [frmReports]![StartDate] <=...

Okay this is what I have going so far: Private Sub Command5_Click() On Error GoTo Err_Command5_Click Dim rsReser As DAO.Recordset Set rsReser = CurrentDb.OpenRecordset("tblRecordDate", dbOpenDynaset, dbSeeChanges) For intCars = 1 To Me.tblRecordDate 'add res for each car...