Search results

I have excel file with 15 sheets Is there a way that I can check if any of the fields are linked to another field or sheet (without checking each field)? Thank you

My main form has 2 “Continuous Forms” sub forms. The cycle of the sub forms is set to “All Records” Is there a way to exit the first sub form and move the focus to the second sub form utilizing only the keyboard? (Like shift + tab, or any custom buttons) I’m trying to avoid using the mouse...

Good morning everyone, The county field is being used on several reports and forms. Some reports are Union and some are a combination of 3 tables. To add the additional tblCounty might be difficult. Is there any other what to leave the reports source the same and just configure the County...

Thank you Joe

I have revised the sample DB to include auto numbers for all primary keys However, I did not add auto number for the state ID, the primary key will be the 2 digit sate name. However, I still need your help. In order to fix the duplication problem, I will have to store the CountyID instead the...

I also use tables where it cannot be setup with relational integrity What should I do?

I appreciate you help. I’m just concerned about using AutoNumbers for the Primary Key. Because, if I use AutoNumbers and store only the AutoNumbers not the value, if a record on the state, county, or municipality tables will be deleted accidentally, and will be re-entered, it will get a new...

How to I format a check box, to display on the report as Yes/No ? Thanks Joe

How to I format a check box, to display on the report as Yes/No ? Thanks Joe

I have a tblState, every state can have multiple Counties, and every County can have multiple Municipalities This should be a One to Many to Many, right???? However, several states might have the same County name In order to resolve this, should I add 2 primary Keys in the tblCounty???? If...

Will this also take care of the sub forms?

Private Sub Command59_Click() On Error GoTo Err_Command59_Click DoCmd.Close Exit_Command59_Click: Exit Sub Err_Command59_Click: MsgBox Err.Description Resume Exit_Command59_Click End Sub

Yes I have a Custom close button with no special functions If I leave the sub forms record source blank, all fields will have the “Name” when opening Thanks Joe

I have a main form that has 10 sub forms Each sub form’s record source is link to a different Query It takes more then a minute to open the form, (because it’s running the query for all sub forms) So I changed the sub forms source to SELECT * FROM tblTest WHERE false; I also changed the main...

I have a combo box on my main form. The Link child filed and Link master fields are configured correctly. I cannot figure out why the sub form does not get update after updating the combo box. (The combo box also uses a function, the function is running but the sub form does not get updated) I...

Yes, it proofed me that I did the correct steps. I have manually split the DB. Let me explain my problem, I’m not trying to change any settings on the FE. But I’m wondering why the “Cascade update related fields", and "Cascade update related records" became unchecked on the FE? I dragged the...

I have a one to many to many relationship; with the "Cascade update related fields", and "Cascade update related records" on the relationship properties checked. Since I have split the DB to FE and BE, the relationship properties (for the 3 tables on the FE) is grayed out and cannot be changed...

When running the code at the BeforeUpdate event, the new autonumber is obtained and it takes less then a second until the record is saved. (The record is saved either when entering the sub form or by clicking the save button) I am not worried that the other user will save the record at the same...

I have revised the code a bit. Private Sub Form_BeforeUpdate(Cancel As Integer) ' Set Record No to "Max" + 1 If IsNull(Me.OrderNo) Then Me.OrderNo = DMax("OrderNo ", "tblOrder") + 1 ' If result is still Null (this is the first Record), set to 1 If IsNull(Me.OrderNo) Then Me.OrderNo = 1 End...

Thanks for your help. The problem with using the BeforeInsert event, once I start completing the fields, the BeforeInsert event is fired. However, the record is still not saved. At that point the second user is opening the same form, the second user will get the same DMax number as the first...