Search results

You obvously have to create the query and force into the acOutputQuery method, but this isnt working. Some syntax help would be appreciated Set tempSql = CurrentDb.OpenRecordset("SELECT * FROM Joblog") DoCmd.OutputTo acOutputQuery, "tempSql", acFormatXLS, "C:\Temp\temp1.xls", True

As in DoCmd.OutputTo acOutputQuery method?

Hi All, I'm trying to write a VBA function to write a table to excel but with filters. I'm using the Docmd functionality but can't find where I filter. Here's what I have so far:- Private Sub Command344_Click() DoCmd.OutputTo acOutputTable, "Joblog", acFormatXLS, "C:\Temp\temp1.xls"...

Hi all, When using Access 2007, I have a new record button, but that record is only written to the db once you navigate away from it. How do I write immediately to the DB, so that record is saved without navigating away from it. I believe I can use ADO or DAO but I'm having difficulties...

Hi All, I have a listbox in access 2007 and I'm wanting to deselect an item if it is clicked again. ie If I have a list, click once to select an item, then if you select the same item, click it, it then deselects it. How do I get that working? I've tried:- List383.Value = -1 and...

Yeah i had them set to true whatever. You do though need to run the function through a Private Sub Form_Current() function though from record to record. Thanks for the help guys, all working now. Private Sub Check44_Click() If Check44.Value = -1 Then serial.Locked = True gain.Locked = True...

Hi I hope someone can help. I have a checkbox which when checked then turns textboxes to locked as below. However when I navigate to the next record which may not be checked the text boxes remain locked. I obviously want to lock the boxes depending on each record. I am navigating via the...

I was hoping for functionality that would test for > than beginning of the folder name (first sixcharacters) and < last six charaters. I was generalising on the folder structure naming convention. It goes something like this 833300-833399, 833400-833499 etc and going back. it's pretty big

Hi, This code below works, but alot of what it does is unnecessary. I have a directory structure named 1000-2000, 2001-3000, 3001 - 4000 etc and within that is the individual folders 1000, 1001, 1002 etc How do I test to search top level folder thats no larger than correctNum to then test...

Thanks for this. What returns the path of the folder when TRUE? as it's a true/false situation

Hi I'm trying to check a directory for a folder name which has a certain string in it (RecNum) However the fso object filesys.FolderExists does not take an argument when looking for part of a folder name on a particular path. What I basically want to do is look in a directory for a...

Hi I'm looking for copy folder functionality and I can't find anything. In access 2007 when I push a button on a form, I want to copy a network folder to another location and rename it. Anyone any ideas? Thanks

Thanks, This is how it worked for me:- MaxValue = DMax("[Record Num]", "Joblog")

Hi I'm trying to do a sect statement and put it in a variable which i can then output to a text box. How do I get the value into a variable? I can't seem to get my syntax right this is what I currently have Maxvalue = "SELECT MAX[Record Num]FROM Joblog"

Thanks for the reply, but that didn't work for me. The strings do have spaces in them so it may be that. I have to put square brakets in perhaps but not sure where?

Hi Im trying to pass a list box variable in a select query. I understand you cannot pass a variable directly but have to pass it through a function. I may be wrong in this, but whatever I do I cannot get it to work. Here's my code:- Public Sub GetEquipment() List387.RowSourceType =...