Search results for query: *

Hi I am trying to use FindFirst to find a record on a form, by entering the ID into a textbox called txtGoTo. The form is bound to a table containing the record. I have searched this site and found the required syntax but still it wont work. What am I doing wrong? Thanks in advance for any...

Hi, its been a long time since I last posted, as I can usually find answers by looking through other people's posts. But this time I have a problem which I just cannot solve, despite all the help there is out there. Using Windows 10, Access 2016 and VBA 7.1, with a database that was designed...

I always have trouble with concatentaing strings and text and can never work out whether and/or when to use a single or double apostrophe!!! I know this is simple but I just can't get it right... txtInstructions is a textbox on a form in a MS Access 2003 database. I am trying to change the...

Hi I have a simple loop which I cannot make work - please tell me what I am doing wrong! I have a list box (lstDate) in which the user selects the dates they want. lstDate is bound to tblDate and has 4 columns; ID, Date, HolidayName, Outing. Outing column is Yes/No. If the user picks a date...

In Access 2003, have a continuous form with three textboxes: [PaymentDate] [PaymentType] [PaymentAmount] To edit a record, the user clicks on PaymentDate, and a single form pops up showing only the record selected. I want the PaymentDate texbox to change to FontUnderline = True when the user...

I want a form to go to a new record, and fill in the ID from another form that is open at the same time. There are two forms that this form can take the ID from so I have been trying to use the IsLoaded function to determine which form is open. Here is my code: DoCmd.GoToRecord , ...

I am a complete newbie, in the final stages of my first web site. I have used FrontPage, and do not know much about code. I have used the email encoder I found at http://hivelogic.com/enkoder/form to encode my email address to reduce the risk of spam. All working well. However, I want to...

Hi. I'm having trouble with filtering data in a form. I have unbound text boxes in the form header where the user can type one or more filter criteria, then a command button which applies the filter on the Click event. Here's my code: Me.Filter = "[Surgeon] = '" & me.txtSurgeon & "' OR...

I have a list box populated by a series of dates. The user (multi)selects the dates they want to book, and then click a command button "Make Booking". I want the command button to run an append query, which will append the selected dates (and other info related to the booking) into a table -...

I want to create a duplicate main record, then duplicate its subform records, then change the ID that links the subform records to match the latest main record (the overall aim is to reduce data entry when there is only one field that is different). So, the main form has these fields: PDMenuID...

I have a MS Access 2003 db that produces a report which contains a separate invoice on each page - each page is an individual invoice for each client. Currently the system is that each month I convert these to .pdf, save them, print them, and hand out each invoice to each client. I would like...

How do I change the default error message that comes up when users try to enter a duplicate primary key? The default error message is "The changes you requested to the table were not sucessful because they would create duplicate values.." blah blah. I want to replace it with something they...

I hope this is an easy one for someone to answer - I've searched everywhere and can't find any explanation. What do {} parentheses mean when they are at the beginning and end of a formula in a cell in an excel worksheet? Here's an example of what I mean...

I have a table showing date, lab test type, and Lab test results for each patient eg: PatientTestID PatientID TestID TestDate TestResult 1 10 x 15/1/06 105 2 10 y 15/1/06 200 3 15 x 10/10/06...

I understand that relationships belong to the tables, which are in the back end, and the front end is linked to those tables, so inherits those relationships. Hopefully I've got that much right. I have an just created my first Access 2003 database and split it into Front end and back end...

I have a report in Access 97. There is a text box on the report, that is bound to a field in a query. When I run the query, the field returns the results expected, but on the report it comes out with the last few characters missing. The text box is set to CanGrow = Yes, so that is not the...

I am building a database in Access 2003 for my not-for-profit childcare facility (why do I volunteer for these things??). Its purpose is to keep track of kids, parents, and sessions attended. So far, so good. We also want it to keep track of fees charged and payments made, so we can send out...

I have a table called tblTransaction. Its fields are TransactionID(Autonumber), TransDate, Amount. I want to get a running balance eg: TransactionID TransDate Amount Balance 1 1/1/05 10 10 2 2/1/05 6 16 3...

I have an Access 97 database on a network, split into front-end, back-end. I want to archive all the records that are older than 2 years into another back-end (archive_be.mdb). I have written some code that will run some append and delete queries to copy the records, then delete them from the...

I have a MS Access 97 database running on a network. Each night the database is closed down. At the beginning of each month I start up the db, and run a function which in turn runs a series of action queries. (The aim is to append some data from a holding table into an 'active' table, then...