Search results for query: *

Hi I am moving data from one database to another and I am using the follwing method to remove commas: rs2!MyField = Replace(rs1!Reference, ",", "") I also need to reduce the field length to a max of 35 characters. How can I do this? Thank you

I have a datasheet which shows hundreds of records. One of the fields in each record is a checkbox. I am looking for a way of ticking and un-ticking all checkboxes on the datasheet simultaneously using a command button. Please can anyone help me out with the code? Thanks

PLEASE HELP I have a SQL database that uses an access front end and I would like to output each individual record when a check box is ticked. I am (somewhat vaguely) aware of 2 ways of doing this: 1. to output the file using vba DoCmd.TransferText acImportDelim etc… 2. to use SQL triggers...

I am using an unbound textbox with a Dsum calculation as the source to work out totals on an access form. The Dsum is a follows: =DSum("[SumofDaysLost]","qrySickCount","StaffID =[SickList].Form![StaffID]") The problem I have encountered is that with this...

Hi I have an asp form that asks a user to put in 2 strings of reference codes to look up a record. This has been done using a submit form with input text boxes. The reference strings each consist of 8 numerical cahracters. Some of the strings contain preceeding zero's but users are just used...

I am displaying a series of records in a datasheet format which have a checkbox field that the user should tick to confirm they have checked each record. On closing the form I need a popup to inform the user that there is at least one unchecked record and give them the option to continue with...

I have a problem in that when some users open certain forms within a database and use the forms, after they have closed the forms and exited the database they cannot open it again. I have noticed that the MSACCESS.EXE process is still running. If I go into TASK MANAGER and PROCESSES and then...

I have an access database that outputs records including email address and issue description to a word document, using access vba and word bookmarks. The document is then completed by user. I want the user to be able to click a button and then for the document to be sent using outlook. I...

I have an access database that outputs records including email address and issue description to a word document, using access vba and word bookmarks. The document is then completed by user. I want the user to be able to click a button and then for the document to be sent using outlook. I...

I have upsized the tables of a database whilst keeping the forms within an mdb file. The intention is to distribute the mdb file to many user's local drives to reduce network traffic. Problem I have is: I cannot run certain queries any more because they have the group by and count functions...

I have a lookup form made in access where users can search for specific records in a separate database. The two reference fields each consist of eight digit numbers. Any of these numbers less than 10000000 must have preceding zeros typed into search form, for example 00000345. I was wondering...