Search results

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

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 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...

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

Can anyone help me in creating a field from a query which will pull the first word only from a specific field. Thanks.

I found this module some time ago and has been used in most of the databases I've created since. This will calculate the time diff (currently set to minutes) between 2 dates, it also removes the time between 5:00PM and 9:00AM so only calculates the time during the working day. With the use of...

I have a database in Access 2003 which is currently in creation but keeps getting errors and changes a records font into Chinese symbols. The 'corrupt' record also jumbles the fields around so the text that doesn't turn into Chinese font is in a different field completely. I've gone through...