Search results

Hey Not sure if this one is possible. I've looked around the forums and the internet, but I can't come up with a search string specific enough to help. I would like to open up a windows folder so the user can view it. For example C:\Example\New Folder. I also would like to open a .pdf file...

I've got the same problem although it's just a straight Access 2000 database, it hasn't been converted - anyone with a solution (or explanation as to why) to this one? Thanks

Thanks Parker, I'll have a play. :D

Thanks for that ByteMyzer. It is definately an improvement. However if the job doesn't have the subjob digits, then I don't want the hyphen either. so it is 5678 or 5678-56 not 5678- It was the hyphen I didn't know how to make optional - sorry I should have explained better. Any...

Hey Everybody I have imported tables from a foxpro database (as readers of my other problems will be well aware). Part of the problem with the imported data is the jobno field. The jobno is either 4 digits - like a pin number. i.e. 5678 etc. or is 4 digits "-" 2 digits to indicate a subjob...

Thanks rich :D

I'm not sure you understand me. I mean in code. Thats why it's in the VBA forum. eg. me.name = 5 move.nextrecord me.name = 10 move.nextrecord etc.

Sorry for all the questions today guys. I do try and find answers with search, but I rarely know what to search for. On a continuous form, how do a move through the records. Thanks

Sub cmd2_Click() cmd1_Click End Sub Oh - does this do what I want ?! I'll try it out. If it does, then thanks. :D

That will be useful for something else - thanks However not quite what I need in this case. cmd1_click imports the data from no.1 spreadsheet for no.1 member of staff cmd2_click imports the data from no.2 spreadsheet for no.2 member of staff etc. etc. I want cmdAll_click to 'click' each of...

Strange problem - but I'm sure it's possible I want to click a button, and doing so, cause the OnClick event on another button to run. The reason for this is eventually I want to be able to click one button that effectively runs the code for a dozen buttons. Thanks in advance

Hey Part of the system I'm writing involves importing timesheets from Excel spreadsheets. I have the importing sorted thanks to some help in other threads. ;) However, the importing is done 1 spreadsheet at a time, specified by the user. What I need to do before that is check the integrity...

Same problem again. The query asks for a year period and the form displays the result. I need to capture what the user inputs so I can use it. Is there a way? If the answer you gave before is the same then I didn't understand your answer. I want to do the equivilent of me.mytextbox =...

I'm sorry, what? I haven't decided to capture the data in excel at all. The data is already there. I'm importing it into Access. I wasn't asking you to solve the solution either. I had followed someone elses advice as far as I could and was asking them to elaborate. The_Doc_Man offered the...

Sorry - it was my own stupid fault. It was part of an excel opening/importing thing. I was closing the excel window, and then going back to Access to finish the program. Because I had closed down the Excel window I got the above error. Thanks

Hey all I keep getting this error :- on this line :- If xlSheet.Cells(DataEnd + 1, 3) = "" Then I have several lines of code like the one above in the module and the program seems to randomly pick which one causes the error on each run. Any help much appreciated. Thanks

Great post thanks -some very useful tips in there. Thanks :)

Thanks for your ideas guys. I've spent a while trying to link to a new workbook without the fancy formatting. I've got the cells updating automatically etc, but I don't see how I can automate the task of getting them into Access or making these extra sheets. There is a spreadsheet for each...

Hey guys. I've searched around a bit on this one, but I'm not finding what I need. Staff here used to fill out timesheet information on a sheet of paper, hand it to an admin staff member and she then typed it into a Foxpro database. Recently, with progress being made on my Access system that...

Incredibly fast answer but not quite the problem I tried to write down. I'll explain a bit more. The Yr_prd is something we can't change at the moment. It comes from a Foxpro database store that is very 'resistant' to change, and in this case the format of the yr prd is unchangable. The yr...