Search results for query: *

Thank you!

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

Thank you - this works just fine.

How do i format the number to exclude commas?

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

Thanks - that's great.

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

Thanks for your help. This works but only if any records exist. If there are no records then there are no checkboxes to test. My datasheet has a requery facility that will get rid of records that have been checked and bring in new records that are waiting to be checked. If there are no...

Thanks for this. I guessed that the on_close event would be the most appropruiate place to add the test. The way I am planning to do it is to use the on_close event to run a procedure that tests the checkbox in each record of the datasheet form to make sure they are all TRUE. If it finds a...

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

Thank you for this information. I will check all of the code and post my progress.

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

Thank you both. I have converted column types and columns to INTEGER to use group by. This works fine. Terry - I have just had a look at your site: http://tlbroadbent.home.attbi.com/sql/sql_articles.htm This is excellent - it covers a lot of the information I need to know about. I am making...

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

Again, excellent. Thanks

Excellent - many thanks.