Search results

Ok Chewy, here is what I did. I ran both of these in the code you provided: fCopyFile "R:\Audit_Shared\RC\Shortcut to RenewalCalendar.lnk", "C:\WinNT\Profiles\all users\Start Menu\Programs\StartUp\Shortcut to RenewalCalendar.lnk" fCopyFile "R:\Audit_Shared\RC\readme.txt"...

FileCopy strDir & "Shortcut to RenewalCalendar.lnk", "gstrStartMenuPath & "Programs\StartUp\Shortcut to RenewalCalendar.lnk The directory structures work because I have been able to replace "Shortcut to RenewalCalendar" with a text file in the same directory, and it copies fine. Were you able...

Hi Chewy, Yes, I ran it first before I posted my last message. I get the same "File Not Found" message that I always get. Are you trying to copy a link? I am able to copy files out of the given directory but not links. Any thoughts? Thanks, Big Jim

Hi Chewy! Thanks for the reply, but I forgot to mention that filesystemobject does not allow you to copy shortcuts either. Any other suggestions? Thanks again! Big Jim P.s. Big Jim loves the SuperNintendoChalmers thing.

Hi, Big Jim here! Was wondering if there is an easy way to take a link, copy it, and paste it into the Windows Startup folder so that the link will open along with Windows. Tried FileCopy, and that doesn't seem to work with shortcuts. Thanks! Doug

Thanks border! I agree with the second part, but should this really slow the macro down by upwards of 400%? We have a macro which used to take us 2 days to run while connected to the network, now we can get it done in 4-5 hours. Anymore thoughts are appreciated. Thanks, Big Jim

Hi, Big Jim here: We, including Big Jim, were wondering why our queries run everso much faster when we disconnect the computer from the network, reboot, and rerun our macros. All we have in the macros are queries located on the hard drive, but the computer moves much much faster. There are...

pdx! You are the man! (as your name rightly suggests) Thanks again, Big Jim

Hello, Big Jime here. Say I have this labels: lblName1.Caption I would like to reference it using variable strLabel: strLabel = "lblName" strLabel & "1" & ".Caption" = "Big Jim" I would like to do this without using an array. Thanks in advance! Big Jim

Thanks again Pat! Big Jim is most appreciative! Big Jim

Hi, Big Jim here: Any suggestions on where to go to download components (controls) for use in VBA and VB? I am sure they are out there somewhere if you know where to look. I also seem to be missing my calendar control, so it would be nice to find a calendar out there. Thanks in advance! Big Jim

Hey Mike! I am not sure if I can provide a direct answer, but is it possible to store the selected values prior to the form becoming hidden? Perhaps in a global array? Good luck! Big Jim

Hey Barbar, I think I am getting closer to understanding what you want. You are looking to run some queries at a specific time. Well, I think the best way to do this in Access by itself is to use the Timer Function on a Form's Properties. Create a new form to work with. At the bottom of Form...

Hey babar, Tell me a little bit more about where you are running these actions from? I mean, do you want to run a query from another database while you are still in Access, or are you using Excel? VB? Do tell... Big Jim

Wayne! Thanks! Very cool website! Everyone should check it out, as they have some cool stuff. Thanks again! Big Jim

Wayne Ryan! Your idea was very ingenious I think. To answer your question, I create (on the side) some in-house applications for my business unit to expedite using Access. One of these applications allows the user to enter a string into a text box. That string is than compared to the SQL of...

Hi, Big Jim here.... Say I have a listbox with Items A,B,C,D and E. C,D and E are all highlighted. I would like someone to be able to double click C and have my code retrieve the value of C. How can I do this with the others (D and E) selected? Looping through the ItemSelected will not...

Ironis, I appreciate your help....unfortunately, referencing the cell is the problem. When the value of the cell is NULL, it returns 0. Thanks for responding! Big Jim

Hi, Big Jim here: ************ (some code ommitted) Dim sht As Excel.Worksheet Dim wkb As Excel.Workbook PreSale(i).RFPLogin = sht.Cells(1, 1) ************ In cell (1,1), there is a null value. However, when I run the above line, Presale(i).RFPLogin becomes = 0 as opposed to null. When I...

Travis! Jack! Thanks for all of your help. It looks like a great solution you found there. Thanks again! Big Jim