Search results

Actually to make things easier to understand... here is the code I started with (the code works great). I'm not ashamed to say it came from Access2007 VBA Programming For Dummies. lol I just need to select the second sheet in the file. This code always selects the first sheet. Private Sub...

I export data on a daily basis from Access 2007 to Excel 2007 with no problems. Okay... this works and places the data in the first worksheet of the document. MySheetPath = "T:\Dept\HotDogs.xlsx" I have a application where I need to place the data in the second sheet of the document. I tried...

Okay. I figured out what was wrong. I was working in a data base that someone else had created. They linked tables a different way than I did. Their connection looked line this in the linked table manager. C:\\WINDOWS\ODBC\Data Sources\{Library Name}.dsn I simply relinked all the tables...

No ideas on this one? :\

Hi All, I have a module that I call when loading forms to eliminate the need for repeatedly asking of IDs and passwords for ODBC connections. This exact same module works fantastic on over a dozen databases that I have built. However I have one database I simply can not get this to work on...

Cha-Ching! This worked!! Example 6 Me.Text26 = "C:\Test\" Call FillList("C:\Test\") Thank you soooooo muuccchhhh!

Yep. I tried. Still no luck. Thanks for the suggestions. Example 4 Me.Text26 = "C:\TestFolder\" Call FillList("C:\TestFolder\") Example 5 Me.Text26 = "C:\TestFolder" Call FillList("C:\TestFolder")

Yes. I also tried (I'm guessing you didn't want me to use the *): Example 3 Me.Text26 = "C:\Test Folder\" Call FillList("C:\Test Folder\") I can make do with just putting it on my C:\ drive for now but if anyone comes up with a solution please let me know. :)

ajetrumpet, I know this is a old post but thank you so much for posting this ftp to network database! I do have one question about it. For example if I wanted to save a ftp file to a folder in my C drive what is the proper way to type this? Example 1 (this works) Me.Text26 = "C:\" Call...

I am working in MS Access 2003... in case that makes any difference.

I know this is probably explained in this forum somewhere but I just can't find exactly what I am looking for. What I want is to update 2 millisecond time fields bases on a comparision between a current row field and a previous row field. In the attached JPEG I would want the results to...

Thank you soooo much!!! :)

Can I highlight certains cells in a particular column using VBA? I have attached a simple example. I want to highlight "Due Date" cells that are older than 30 days that do not have a date entered under "Date Complete". So in the attached example the only cell that should highlight would be A5

khawer... I just figured out that I had to change the filename extension. duh Thank you so much. It works wonderful!!

Thanks but I could not open up the attachment.

I am trying to get a end date based off of a next row in sequence for each person by job in my query. My query results keep repeating the same end dates for eack of my persons jobs. I think the attached picture and database will make things pretty clear. Please let me know if I haven't...

but I can't seem to figure it out. All I get is Null values when I run the query. I have a form with a start text box and a end text box. I use the form name sucessfully in the criteria row so I know there is no problem with the form name. I also know there is no problem with the qry name...

Thank you so much! This forum is GREAT!

I tried this... but it didn't work. Maybe the ACCESS.EXE is the wrong terminology? Not sure how to do the FollowHyperlink. Private Sub Command15_Click() On Error GoTo Err_Command15_Click Dim stAppName As String stAppName = "ACCESS.EXE T:\Database\HF\bastool_30_2000.mdb" Call...

Our company has many access databases. I would like to create a main form that would allow me to open other databases with the click of a button. I have been able to do this with no problems for excel files (see the example below). I just don't know what to do to get the access databases to...