Recent content by Nick34

I want to import data from a spreadsheet automatically. How can I tell access to import a particular range of the spreadsheet, as in range("A15",range("A15").end(xldown).offset(-3,0))??? I want access to append this data to the bottom of an existing table in my database. Is this possible? I...

I just tried your suggestion and it was a no go. It works without the choose statement i.e., between 50 and 190.4.

Does anyone know why this statement will not work in the WHERE statement of my query??? Choose([1=Low Load; 2=Mid Load; 3=High Load],Between 50 And 190.4,Between 190.4 And 330.8,Between 330.8 And 518) I can't figure it out. Thanks.

I am using Access to send an email automatically, however, it will need to go to a lot of people so I wanted to create a distribution list. With oRpt .to = "Distribution List Name" .send End with Does not work because as far as I can tell, it takes too long for the distribution list...

When I step through this, it thinks the foundfile.count is NOT > 0. However, I know that there are files there because I used the same sPath variable to output them there. This is why I am getting confused.

Can anyone tell me why this might not work assuming that I have the path name right? With Application.FileSearch .NewSearch .LookIn = sPath .Filename = "*.rtf" .FileType = msoFileTypeAllFiles If .FoundFiles.Count > 0 Then Kill (sPath &...

Thank you!

I have tried that syntax, but am getting the error message "Type mismatch" Why is that?

This is the code I'm working with: Dim oCal As MSACAL.Calendar Dim pdCalendarReportDate As Date Set oCal = Forms("Switchboard Subform QC")!ReportDateCalendar pdCalendarReportDate = oCal.Value Debug.Print pdCalendarReportDate Set oCal = Nothing The Set command is whereI...

I am trying to set an object variable to a calendar object that I have created on a form. I can't seem to get this. What is the syntax for referring to a calendar control???

If the printer is available on the network, but is not necessarily selected at the person's who is using the database's desk, do you think that it will still work?

I have some code that automatically prints a report when a button is pushed. Many people will be using this application in different places and I need to be able to print to the same printer every time. I see that there is a printer object, but can I set a particular printer on the network...

No problem at all. Thanks. I'll be waiting...

Is there a way to disable the close button on the title bar?? The one that closes the database, not the report.

How would you make the first form that opens invisible?? I don't see anything to control that.