Search results

In design view of your form, change the default view to "Continuous form". You should get back your combobox.

In order to achieve what you just descrbied, you need the query to contain the following fields: - Head of Household - Address - Phone# In the after update of your combobox, you need to add a sub: Private Sub ComboboxName_AfterUpdate() Me.Address = Me.Comboboxname.column(1)...

Review the parameters (usually field names) you supplied to your query. It seems to be looking for some parameters specified in your query but could not find it. Review all the criteria as well. There could be some typing errors somewhere.

Try: Select OrderNo from tblOrdersAudit where Bill_to=false AND ship_to=false

Try using the Dcount() function with the "other" table as your domain. You must supply 3 parameters in this function: e.g. Dcount("[fieldName]","tablesource","your condition") Basically, if the dcount() results in >0, then it would indicate that the item is present in the other table. You can...

One way to do it: In the "On Load" property of your subform, filter out any record with type = "Car". Code: Me.recordsource = "SELECT * from tableName WHERE Type <> 'Car' "

Try this: - In design view, right click on the report - Select "Sorting & Grouping" - Set the "Keep Together" to "No" I think this will solve your problem.

Try: DoCmd.RunSQL ("UPDATE tblStock SET Quantity = Me.[Restock] WHERE ItemID = Me.[ItemID]") Assumes that "Restock" and "ItemID" are both textboxes in your current form.

If the two textboxes are not bound to the record source of your form, then you have to use VBA code to enter/edit a record in your target table. You can use a DoCmd.RunSql statement to either edit a record or add a record to your target table by supplying all the necessary parameters e.g. field...

In design view, you will find "On Load" under the "Events" tab of the form properties. This is where you need to write some vba code to set the visibility of your form elements depending on which user is appearing in your text box. In this case, the user name is synonymous to the network user...

One possible way: Create a textbox in your form and use the "environ function" to capture the user name. Store this in the textbox. You can set the textbox visibility to false if you desire. Now depending on the value of your textbox, you can set elements' visibility in your form to true or...

One strong reason you'd design a table with automatic PK's is to have some assurance that no record had been deleted maliciously or accidentally. The continuity of your primary keys (ie. no numbers missing) would be your assurance that all previously entered records are indeed in the table.

It appears you have a problem with trailing spaces. Try trimming it out using the Trim function.

I use date ranges to filter reports with no problems. If you post a your db (limited records), I will look into it.

What error message are you getting?

In the report footer section, type in: =Sum([FieldName]) Substitute your own field name.

Try: = CStr(Year(Now())) & CStr(Me.f00)

Create two calculated fields in your query: =DatePart("d",[YourDateFieldName]) ------ the system will assign a field name called Expr1 =DatePart("m",[YourDateFieldName]) ------ this one will be called Expr2 Set the criterion of Expr1 as: DatePart("d",Date()) Set the criterion of Expr2 as...

This is an example of how you will concatenate date parts into a string: (Assuming you have a form with a date field called "txtDate" and another control called "txtToday") Me.txtToday= DatePart("d",Me.txtDate) & DatePart("m",Me.txtDate) & DatePart("yyyy",Me.txtDate) Try adopting this code to...

Try using the DLast function instead of DLookUp.