Search results

Hi there, I am creating an orders database type thing and am struggling with updating info in a subform. I have three tables in my database one for customers, one for orders (which has fields OrderID and furniture category) and one for customer orders. In my form I am displaying the customer...

What line of code is required to move to the next record? i.e. the code that would apply to the move one record to the right navigation button. I need to turn of the navigation button so that the user is forced to press a cmd which also runs an append query. I'm in data entry only form. I've...

Hi Access Afficionado's, I'm trying to knock out some records like so in VB: sSQL = "DELETE * FROM [Attendant circumstances] WHERE (Year([Date]))LIKE " & MyYear g_DataConnection.Execute sSQL sSQL = "DELETE FROM [Casualty Details] WHERE [Casualty Details]![Crash Reference] NOT IN...

Hi Readers, I really hope someone can help with this. I want to look through 2 tables and if the PointID in one table does not appear in another table in a field called Accident Key then I want to delete the record. The code I have used is below, similar code works on other tables, but PointID...

Folks, I've got my continuous form which has a sub query as its record source. The sub query is based on a xtab query. The columns in the form represent age ranges and each range has a count and percentage for the type of child restraint used. All I want to do is have a total for each column...

Hi folks, here is my SQL TRANSFORM Count(childinfo.agechild) AS [The Value] SELECT childinfo.chilRestraint FROM childinfo GROUP BY childinfo.chilRestraint PIVOT childinfo.agechild; at the moment this SQL gets the count, I want to do another a query which instead of the count will show...

I'm getting a write conflict in one particular field, whether I try and alter it in the Form or the table? I'm the only person using the DB, it was a shared file, but no-one else will be using it. I took off the sharing and it still won't update the field. Currently the field is storing #error...

Hi Everyone! How are you all today? I've been doing some queries and have cracked most of them, the last one's may have to be crosstabs, please take a look at this example: ________________________MAIS________________ CHILD RESTRAINT______0___________1_________>2 Infant carrier Booster Cushion...

Hi Peops, I want to display info like this as a continuous form. Highest AIS Total Percentage 0 1 >+2 Highest AIS can be up to 9. I don't reckon i'll be able to do a count of all >=2 on one record of a query. Thanks to some help I have done similar queries but the >=2...

Hi, Someone has asked me to do a bunch of queries I thought they looked easy and they might be, but i've got stuck. most of the queries are of similar style, i'd like the output to be like this: [Child Position] [Number] [Percentage] Front Passenger Rear-Right Rear Centre Rear Left Unknown...

I've got five similar fields where I want to use the same code for the keypress. Instead of pasting the same code 5 times i'd like to call another sub, but whatever I try I get variable not defined or argument not optional Private Sub AIS3_KeyPress(KeyAscii As Integer) Call...

Hi peops, I know how to let the user see multiple columns in a dropdown by setting columns widths likes so: 5cm;4cm etc... and also changing column count but after the user makes a selection how do I get both columns to still show in the combo box thanks

I know this is easy but haven't done it for ages and can't find my book. I've got a form of accident details. The form it's based on has a vehicle ID field which is the foreign key. I want the user to be able to select the model and make of the car from the combo boxes then Access will store it...

Simple problem I want to delete all records from a table where the year is the same as entered in a text box. The format of the date column is dd/mm/yyyy can't seem to get the syntax correct to look for the year within the date. I've searched but can't find an example, although it must have...

I have to write a program in VB that will delete some records from a database that the user browses for on a VB form. The user will be able to enter the year that they would like to delete the records from. Then the program will open a recordset and look through a table of accidents and delete...

Hi Everyone! Just wondering, does anyone know if there is a forum as good as this for C programming. I've just started using it and have done an Internet search, but didn't find the sites as useful as this one. cheers Rich

I'm doing an export program in VB to export records into Access. I want to add a progress bar as there could be a large number of records. Here's what I've got currently: pbrExport.Min = 0 pbrExport.Max = mrecData.RecordCount intCounter = 0 'Do... loop to Add some records to text file...

Greetings Folks! I'm trying to write code to remove zero's from the start of a road number. The problem is that there are normally between 1-3 zero's at the start, so i'm not sure now to set up the expression sought. I then want to "trim" off the zero's. Anyway I'm having problems achieving the...

In my code I'm adding in extra data to my tables with an export program. I'm storing the last value for the primary key in a public variable called AccKey then importing the new data to the table. How can I find the value of AccKey later on and move back to that record. I've been trying Seek but...

I'm trying to count the number of records in a table, normally i'd do a dcount. But I'm trying to correct a problem in some VB code, which appends new data to an Access dB. How can I code it to count the records in the database from VB? cheers Rich