Search results

Thanks guys. That is get me closer to final solution. The problem now is that the code fires when I click on any tab, causing the msgbox to appear saying you don't have any data in the Date of Submittal field. I only want that to pop up when I click the Submittals tab. Any ideas on how to make...

When opening F_Project form to a specific ProjectID, I have some code to check if 3 fields are populated. If they are populated, then all the other controls that are Enable No, change to Enable Yes. Otherwise the stay with Enable No. This method works for all the controls that are on the...

I suppose you're right. I didn't consider that until after I had posted....drats.

Well that sounds nifty! Care to share or is it for sale? It may be to custom for a general application I suppose.

I will double check the access to navigation pane. I know I have it hidden but you can still press F11 to make it show up. The only other thing that I can think of is, sometimes I’ll intentionally bring the tables in and work on the database from home. Perhaps I messed up and sent an update...

I've had this happen twice now in the last 6 months. A user's FE suddenly has the linked tables from the BE removed and all the tables are now embedded into their FE. Of course this is a huge problem as they are now inputting data to their own tables and not the main tables. When it first...

I’m a believer now. Thank you for stirring me in the right direction. I do appreciate it.

I’m still a bit shocked that I was never taught or read something on this before. This is foundational to setting up a DB, is it not? I’m also shocked that my DBs have been working fine (up until this instance) without me specifying sorting when using tables as a record source for forms and...

Thanks guys. I'm a bit blown away right now. I truly did not know this before. I was never taught that I needed to specify the order between a form and a subform once they were linked with the PK. I though it would always pull the records in order. So C&R does not work on the BE when someone...

No, that didn’t happen. When trying to figure this out, I took the two tables and drug them into a completely new database. So the new database only had the two tables in it. No forms, queries, modules, vba, etc. I then created a query and joined the two tables to the PK of table1 (one to...

I understand in general, but not sure I understand in relation to my database. In my database: Parent Form (F1) - Record Source - Table1 Subform (F2) - Record Source - Table 2 All my tables have primary keys and the tables present the data by record...in order. Always the same order...

I had a strange thing happen in my split database. Some of my subforms records were not in order. The parent form was fine but the subform would show the last record first. Both forms had tables for record sources. There was no sorting on the forms. I tried everything..... a couple hours...

That makes perfect sense and is a great tip! Thanks Pat.

Thanks Pat. I’ll make that change. When you say, it’s more appropriate to have the code in the form vs the combo box, is that more coding technique or can you run into trouble if it’s in the combo box?

Maybe I got it...? I placed this code in the BeforeUpdate event of the cboContractNumber. What do you guys think of this solution? It seems to work. Private Sub cboContractNumber_BeforeUpdate(Cancel As Integer) Dim myMsg As Integer 'True = -1 If Nz(Me.cboContractNumber.Text, "") = ""...

Attached is Sample DB1 of how I set this up and what the problem is. Below shows the sample db screen shots. Note the Contract Number 75H33333333, and the Record Source for the SF_Contract is TJ_ProjectContract. I want them to be able to delete the whole record, i.e. ProjContID 4 in the...

You’re right, I’m not giving the whole picture. I don’t have my computer with me so I’ll respond tomorrow with many more details.

The combo box is bound to the ID field but the ID is not shown in the combo box. So when a user deletes the shown field (ContractNumber) it leaves a record with an ID but no ContractNumber. I want to prevent that. Again, I want to be able to delete the record (no problem there) but no allow the...

I have a sub form linked to a parent form. The sub form is a continuous form. It’s record source is a junction table. There is only a combo box in the sub form. Besides having the ability to select a record from the drop down, I want the user to be able to delete a record (after a warning...

Thanks Pat for the help. I changed a few things only for what I wanted to see, but your solution is spot on! The combo box, cboContractNumber, now only has one query as the row source. Below is the SQL for it. SELECT DISTINCT T_Contract.ContractID, T_Contract.CloseOut...