Search results

cheers, I'll check on Split, Left and Instr.

I'm trying to create a query that gives me the first word in a field but am having some difficulties. I'm using Access 97 (Dated I know) but also have Access 2003 if I need to revert as a lot of code does not work on 97. Any help appreciated. Pete

Please note this is an Access 97 database.

Try the module below... you can set the size that you want the database to compact at.. I have added an extra msgbox to allow the user to decide. Public Function AutoCompactCurrentProject() Dim fs, f, s, filespec Dim strProjectPath As String Dim strProjectName As String strProjectPath =...

I have an automatic compact function for an Access 97 database which works fine but I would like the function to only run when there is only 1 person accessing the database. It is currently on exiting the database the users will be prompted with a yes no to the compact function, but I only want...

I'll try and cover your queries: For developer view hold shift, you can also use the taskbar, right click and select restore. F11 will show you the database window. You only need to have this run once on your first opening form... it will carry forward from then on unless you use reports...

Try the attached it has a flash form on open which starts the Hidden view. Then you will see that the Navigator has the same plus on close on all forms opens the navigator. Let me know if you still have problems with it or don't understand how to carry out another function. Pete

I'll try and cover your queries: For developer view hold shift, you can also use the taskbar, right click and select restore. F11 will show you the database window. You only need to have this run once on your first opening form... it will carry forward from then on unless you use reports...

Totally against the book but I generally add data once I have my table structure.. I find this an easy way to know whether your processes are working correctly as you know what the results should be..

simply use the toolbox to add a combo box, within that box you can change the Row Source to be based on a table or query (doesn't matter for the first one) Do the same again, only this time your Row Source will be a query with the criteria based on the value above.

You can completely hide all access background and only have the form visible by using the module below: Option Compare Database Private Declare Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long Dim dwReturn As Long Const SW_HIDE = 0 Const SW_SHOWNORMAL = 1 Const...

quick and nasty would be to sort the data by the score and use an autonumber field to number them from 1 to..... whatever.

I normally use a hidden form that holds all user data based on what name was selected on logon screen. i.e. Username Password Department Email Address TelNo (all held in tbl_Security) If you open this form (hidden) when they select their user name on logon, it can be used to authenticate the...

Unfortunately not that simple. I'm trying to build this into a module with a loop so I do not need to know the grouped values the module will run through the file, find them all and sum their respective values.

I have a spreadsheet which contains a list similar to below where I need to find the unique values, and their total in the next column and paste them in another worksheet as per the Output below. Data COM 150 COM 150 SPF 100 SPF 100 COM 50 Output COM 350 SPF...

You put the function into your macro (which you will have 2 of - mcrHide & mcrRestore) The rest stays in it's own module. You will then call the macro as normal from your forms & reports on open. docmd.runmacro mcrRestore docmd.runmacro mcrHide When viewing reports there will always be the...

I'm trying to build a RAG status report which will then show a rectangle/text box/label with the background colour to match. if done on a form i would have it as: If Me.RAG.Value = "R" Then Me.RagStatus.backcolor = 255 else If Me.RAG.Value = "A" Then etc But I cannot get something similar...

I have created a process that imports data and runs it through some simple queries. I then copy the table to an 'archive' database and remove it from my 'workings' database. I then want to be able to create a link to the table copied to 'archive' in the 'workings' database. Any help would be...

I am exporting an Access table as an xml file and need to be able to identify and replace '&', '(' and ')' as they are not accepted in xml. Does anyone know how a query can be built which will find these characters in fields and update to ' and' or just remove? Thanks

Thanks for that... apart from it needing to be comma's instead of semi colons it works fine.