Recent content by rblair11

The query works great, thank you. Now I have to work on the form functionality.

I've been struggling with this for awhile now. I've been trying to research a solution but I'm not even sure what to search for. I have the following table structure: tblContacts Contact_ID (PK) First_Name Last_Name tblBidPack Bid_Pack_ID (PK) Bid_Pack_Description tblDistributionList...

Thanks everyone for your imput. I'm keeping it the way I descriped with a table that just holds company names. As I continue to build the app, there will be several occations where I only care about the company. When it comes to adding a contact, I used a not_in_list event to add new company...

It is a 1-m relationship. One company can submit several submittals.

I've thought I had a decent understanding of database normalization but I've come across a fairly simple problem that I'm having difficulty resolving. I have a database which I use to track submittals from companies. Originally it was set up as follows: tblCompany Company_ID (PK) Company...

I can post the DB but I don't want to waste your time. The report I have designed and the report I want to create are 2 different things. Maybe I can ask a more specific question. The report is based on 2 tables as shown below. tblSubmittals Submittal_ID (PK) tblSubmittalRevisions...

Problem Solved I was finally able to fix the problem. Here are the details in case it helps someone. Ghudson's code to turn off all toolbars only needs to be inserted on the opening form. Then just reverse the code (change "false" to "true") on a form that you want to enable toolbars on...

Try adding the following code to the afterupdate event of combo 1: me.combo2.requery This is my first attempt at trying to help someone on this forum so I hope I'm not completly off base here :)

I'm trying to create a report that will look like the attached spreadsheet (it was the easiest way I could come up with to explain what I need). The report is grouped. The biggest problem I'm having is trying to draw a line after the last record in each group. At this point I've only drawn...

I have the following code in the on_load of all of my forms to disable all menus: Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i The problem is that when I open a report in preview mode I cannot close, print, etc. Two questions: 1. Is the above approach...

Got it working Thanks again to both of you. I think I had some other small issues (a result of trying to fix the original problem). The main issue being that somehow the default value of cboStatus got set to " " . In case it helps someone, here is the final code I ended up with: Option...

I've seen mention of .movelast before but quite honestly I do not understand how access handles recordset and recordsetclone. I'll play with it but do I put the code in the on_load or on_current? Thanks for the suggestion, I'll let you know what I find.

Thank you both of you. The code still doesn't completly work. If I go into cboStatus and give it a value then the rules kick in. Even if I delete the entry so it is null (blank) the rules still work. Even if I close the form and enter into the same recordset the rules continue to work. But...

Yes, cboStatus is bound to a field in the Recordset. I tried the suggestions here and I still don't have a working solution. The button seems to disable correctly when I'm not on the last record, but when I am on the last record the button is enabled even if cbostatus is blank. After a new...

Ruralguy, the rowsource is a value list. Aleb, I have code in the afterupdate event and it works. The problem is that when I navigate through the record set (single form view) there are records that have the cmdNew enabled when it should be disabled. The problem with relying on the...