Search results

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...

I want to disable the button "cmdNew" unless certain criteria are met. Here is the code that runs in Form_Current : Private Sub Form_Current() Me.cmdNext.Enabled = (Me.RecordsetClone.RecordCount > Me.CurrentRecord) Me.cmdPrevious.Enabled = Me.CurrentRecord > 1 Me.cmdLast.Enabled =...

Here it is. It's still very rough at this point. Thanks!

Thanks for the suggestion It is not a multi column combo. I tried the code just in case but not luck. I also change it back to me.cboContractor.value and found that the same thing happens as with Forms!frmSubmittalEntry.cboContractor.Value. I've found something strange. As I said, after...

I tried and it still isn't working. However, I looked at the properties window for the subform after the code runs and the record source IS correct. I verified this by coping it, opening up the form directly, and pasting it into the record source. I'm missing something. Here is the code...

I have a main form with an unbound combo box. I also have a subform showing records in datasheet view. on the after_update event of the combobox I want to filter the subform. Here is my code (note frmqrysubmittals is the subform and the recordsource for the subform is initially the RS1...