Search results

I haven't been able to try it for a while but now I have I keep getting the error message on the forms load event; Run-time error '2448' You can't assign a value to this object. I can't discover why, its an autonumber I'm trying to take across to the next form to a field which is a Long...

The option on your main menu is a comandbutton so attach the code to the on click event for this button or the form load event Dim varStatus As Variant Dim strStatus As String strStatus = "The database is seraching for the customer records" varStatus = SysCmd(acSysCmdSetStatus, strStatus)...

Here's the SQL for the query SELECT [Product Material Master].[Product ID], [Basic data 1].[BasicData1 ID], [Basic data 1].[Product Type (eg Finished)], [Basic data 1].[Base unit of measure], [Basic data 1].[Material group], [Basic data 1].[Old material number], [Basic data 1].[Ext matl...

Yeah I'm using data entry forms aswell, so when the user opens up the first form the Procut ID is auto created, then for the open form button to take the user to the next set of product attributes associtaed with a new table I have to add this code. Then will the autonumber that was carried...

I'm not sure I've done this right but I got a load of tables all about a new company product. There is a Product Master Table where the new Product ID is created (Autonumber) and then there are loads of tables linked to this with the foriegn key (Product ID). Each of these tables is a set of...

I am almost a complete beginner when it comes to queries and am in need of help. I have a number of tables all linked together like so: 'Product Master Table' contains Product ID (Autonumber field, primary key), this links to 'ProductBasicData1' table (Long Integer foriegn key).This table...

Same here, Let me know if you still get problems

There is a way of using the Access status bar at the bottom of the screen. THe bit that usually says "ready" Dim varStatus As Variant Dim strStatus As String strStatus = "The database is seraching for the customer records" varStatus = SysCmd(acSysCmdSetStatus, strStatus) or you could try...

Ok, I've played around with it, that code great Cheers!

Hi I've had this error message before, I know it sounds like shit advice but try deleting the fields and starting again. Don't use the wizard to create the fields. Set the recordset property of the form to the table you want to add a record to. A box containing those fields will appear...

I have added some code to a transparent button to disable the shift key so that there are no shortcut ways of getting into the design view of my database. I also have a button which enables it again. See code Private Sub Enable_Click() Dim db As Database Set db = CurrentDb...

It's OK, I found the answer almost as soon as I made the post, (dataentry property)

I have a form and its recordset is set to a table. All of the tables fields have been added to the form and there is a 'Add Record' button to add records to the table. However when I load the form I don't want the other records in the table to be viewable. Is there any way I can stop this...

Can't believe I missed that! Too many hours in front of screen! THANKS

I have two forms. The first form contains fields from a table. There is an add record button to add the record. One of the fields in the first form is called (Base unit of measure). The same commandbutton will, once the record has been added, open the second form. The first field on the...