Search results

In the OnLoad event of the subform_search, place this code: Private Sub Form_Load() Me.lblViewReport.Visible = False End Sub

It appears to me that you have not done your "join" or have done it incorrectly. You can use two or more tables as your query source. However, you need to join them using some common fields. For example, in an order entry system, you would normally have one table to contain basic information...

Yes, you can use an autonumber field in your update query criteria. If I understand you situation correctly, you will have to open your table and determine the last number and the ID's of the records you want to update with that number.

You can use color values ie. numbers. As you know, a textbox has a forecolor property. If you assign a "custom color" to this property, that color would be expressed in numbers. That is the number you use instead of vbRed or whatever vbcolor you are using.

I am not surprised that the book doesn't cover the General Ledger module since this is the most complicated part of an accounting system. As far as having separate fields for debits and credits, or a single field with a debit/credit indicator, I must say that the system I am working with at the...

Creating an order would not necessarily decrease the units on hand. I can't be sure how far Northwind takes you, but in a real world scenario, the inventory decrease will only happen after you process the sales order (ie. actually fill the order and ship the units). During this process, an...

Dim sql As String sql = "SELECT * FROM [qry Landuse Survey 2005] WHERE [STREET] = '" & Me![Combo255] & "'" Me.RecordSource = sql Place the above code in the AfterUpdate of your StreetName combobox. I tried it and it does exactly what you do - ie. filter only those records where the street name...

Try using the Dcount function. In the control source of your textbox, type in: = Dcount("[fieldname]","recordsource","criteria") Fieldname is self-explanatory. Recordsource is the recordsource of your subform. Criteria is the condition. After the comma, insert something like this...

Another way to do it is to enter in the control source of your second field: =[firstfieldName]+13 (You can type the above directly on the textbox, if you wish) The value of your second field will automtically recompute after the value of the first field changes.

It appears you'd be better served if you create a modal pop up form to server as your message carrier. This way its always on top and you can control its placement on the screen as well.

Yes, this doable in Access, however, not that easy to accomplish if you are new to Access. As a start, you should research how to make forms and subforms work together. Once you master this part, then you should move on to adding an "onclick" event in your subform that will display the selected...

Try this: Msgbox "Format Changed " & vbCrLf & "Please go back", vbExclamation I'm going by memory and have not tested it, but I think it will work. If it doesn't let me know.

In the top part of the query design where the tables are, right click on the blank space and you will see the "unique" property setting.

Glad I could help.

Try using the Dfirst function to assign a value to your combobox when the form is loaded or activated. e.g. Me.combobox.value = Dfirst("[fieldname]","tablename") I have not tested this, so I do not guarantee success.

Here's a code you can use. Make sure you replace "Combo74" with the name of your combobox. Also inside the Dcount function, replace the field name and the table name to match yours accordingly. Sub Combo74_AfterUpdate() Dim intx As Integer ' Find the record that matches the control...

Definitely doable. In the afterupdate event of your combobox, you'll need to put a code that goes something like this: Me.textboxname.value = Me.comboboxname.column(1) With the above code, you're basically assigning the value of field 2 of your combobox recordsource to that of the target...

For item 1) Create a report then send it using: Docmd.sendreport "reportname" --- read up on this one. For item4) To move your focus and trigger the code, use the Sendkeys command to send the "TAB" key to move focus somwhere else. Hope this helps.

The format of your main form may have been set to "continuous" form. It should be set to "single' format.

Try this: Docmd.GotoRecord , , acNewrec This should will create a blank record which gets expunged if you do not fill it in.