Search results for query: *

Perfect. Worked a treat, thanks very much

The main menu bar has been disabled as well, I can't get to the Tools menu. If you happen to know the vb needed then I can activate from there. Cheers

Thanks but these are already set to 'Yes'. Also I can't even right click on/in the database window.

Can anyone help, I have just been sent a database, and I can't use the right mouse button to bring up any menus. I'm guessing this is a setting within the database(It's occuring for all areas not just on forms). Does anybody know how to reset this setting or even give me an idea on where to...

You could save the entries as Hyperlinks within a the table.

It sounds like the record is trying to save itself as you complete the combo boxes. You need to perform any checks your making without saving the record. This will aloow you to keep editing within the form. Hope this helps. Cheers Taff

lars7 wrote: 'Dosn't work, Theres nowhere in the code to say which access file to import and on click is where the macro was to import the file.' i assume the actual Macro works perfectly so you can just replace the 'MsgBox "You said YES"' with docmd.runmacro "nameofMacro" A bit messy using...

The database is an existing logging style database where a work order is stored and any actions made on that order are logged against it. The team has now decided that they want to know who has done which bits of work for both reference to the order and individual productivity stats. Hence it...

Paul, You've more or less got it already. Try the below but expand for all the cases you require. dim strFormName as string Select Case me.lstname case "Variable1" strFormName = "Name1" Case "variable2" strFormName = "Name2" case else msgBox "Unknown entry selected!" end select...

I tend to use me.refresh This will also save the record for you. Just put the line in the AfterUpdate property for the Control you are tabbing from. Hope this helps Ian

Does anyone know if it is possible to pause VBA code while a User completes a form?? or does anyone know a way to use a combo box on a VBA control? The situation I`m in is that when a user chooses an option form the main menu I need a prompt/form to make them choose their name from a list...

I'm creating a form in Excel and need to populate a ListBox with the results from an Access Query. Can anyone show me how to set this query as the control source or populate it in a nother way? Thanks Ian

John, Try this: strdestination = "C:\folder\" strdate = format(date(),"DDMMMMYYYY") DoCmd.OutputTo acOutputReport, strReportName, acFormatRTF, strDestination & strDate & ".rtf" Ian

Jalge2 You can set up a command button to save the record to the main table. IF you expand the following to match each control with each field it should work. Sub On_click() dim rstMainTable as recordset set rstMaintable = currentdb.openrecordset("MainTable") with rstMainTable...

Sorry but I don`t know the answer to the query part. I`m only using Access 97 which allows me to use the name of a query within the function. Maybe you could use a make table query before exporting and then delete it afterwards? Hope someone know the answer Ian

Slames, The default option for the Transferspreadsheet function is acImport. If you just add acExport before your first , then it should be fine. so: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "TESTAutoExcelDump", "C:\text" Hope this is right Ian

just add .tabledefs onto the currentdb. :) It will then look like: For Each tbl in Currentdb.tabledefs ..... Next Hope this helps Ian

Rick, Cheers that did the trick. I was almost there, but for some reason completely missed the refresh link coomand which was holding me back. That`ll teach to work to late on it :) Thanks again. Ian

Hi, Hopefully someone can help me out on this one :) I have a number of linked tables within my front end database linking directly to the backend. What I need/want to do is to change though VBA the database path for each of these linked tables so they all point to a new folder path for the...

Hi, Is there a way to retreive the size of an array after it`s been declared? E.g dim QueryList(67) as Variant I wish to retreive later on in the code the value '67' or equivilent at the time as this size is subject to change. Thanks Ian