Search results

Title pretty much says it all. I want to be prepared if the server ever takes a serious hit. I'm already backing up the individual databases but I'm not sure if the logins are part of the master db or what.

The subform is probably linked to whoever is in the combobox. What you'll want to do is ensure that nothing is selected there by default. In the form_load event set the value of this combobox to null. Might also be able to set the default property as null as well but my memory is hazy on whether...

Thanks! I appreciate answering something that was already covered.

I have an MS Access frontend to a SQL Server 2000 database. The database was originally an Access mdb that I upsized using SQL Server's DTS wizard. After setting the primary keys and identities for the original autonumber fields I began to test the interface to make sure it still worked. I...

You shouldn't have cost fields in each of these tables. You should have tableEquipment equipmentID equipmentName tableCost costID equipmentID cost Not sure what your loans table is. Computed values should never be stored. Compute them at run time.

I don't remember, does access have the date/time picker control? The trick will be getting the users to enter data in date/time format. I say have 2 textboxes (maybe put a date/time mask on them) and a button, user puts in the start/end of the range and presses the button. You build the string...

I inherited this database and I can't figure this out so I'm looking for some causes. the database is in one .mdb file, the interface in another and links to the database via the linked table manager. The tables aren't normalized, nor was there any attempt at relational integrity (Strike 1)...

Anyone who wants to take a crack at it can check the attachment I uploaded.

The code is run during a Click Event I have stepped through it and it only runs once, but the record appears 2-3 times.

Here is the code Dim insertStatement As String insertStatement = "INSERT INTO tableDisplay (name, manufacturerID, cableID, transportInterfaceID, powerCableID, backLightInverterID, notes) " & _ "VALUES ('" & subFormDisplay!modelNameTextBox & "', " & _...

I want to set my insert such that Insert into tableA (x,y,z) = (SELECT x,y,z FROM tableB) WHERE NOT EXISTS (select x,y FROM tableA,tableB WHERE tableA.x = tableB.x AND tableA.y = tableB.y) Basically I want to insert data in tableA from tableB if it does not exist in tableA yet. Access says...

That didn't do the trick specifically but I finally caught on. I made the assumption that the query critieria were being fed into each new record, and it wasn't. So while I was looking for records that had x,y,z the records being created had x,null,null,null.

It's a query. I can open the query directly and make changes and additions and deletions.

Thanks! That however didn't solve my original issue, which I think something in my query broke, and all I did was copy and paste the sucker. Any suggestions on running that down? I can add records manually, but when I attempt to add them on the subform they don't save to the table, and if I try...

I tried requering it but it says it can't find my subform. This is the proper way to do it correct? Forms!frmWorkshop!frmSubWorkshop.Requery I'm starting to think something in my query got hosed, now I can add things on the subform but they're never put in the table (But existing records can...

Just when I thought I had my problem licked... I created a subforum with an updateable query, and this works. I can view the results of the query, modify them and add new records. However I shortly realized that once I deleted a record (either by some VBA code, or by SQL) that I could not...

I tried that, no change in the problem. I also tried doing it via SQL and that will delete the record, but the problem of the duplication error message persists. What forum could most likely handle this issue?

I have a subform that I'd like to put a delete button on, so that it deletes each specific record. This was left over by the previous programmer for this purpose but without any documentation, and it doesn't seem to work as intended. Using the below code allows you to delete the record, but...

Thanks for the links. Just to bounce this off someone though I have 3 tables, tblClient: ClientID (primary key), FirstName,LastName tblPrograms: ClientID, OrgID, ProID, Semester, Duplicate (all of these fields is the primary key), Role (Role is a foreign key LookupID) tblInfo: LookupID...

What sort of complicated stuff? What is the query supposed to look like? I can't even use the query design grid if I don't know if I'm supposed to pull something specific or not.