Search results

Hi guys, I'm sounding like a right newbie when asking this... I have a VB6 project that mail merges with MS Word 97-2003. Now we have office 2010 and the code doesn't work. I've tried googling all afternoon with no avail. The data source is a txt file with delimited data generated from the...

Quickly noticed there is a space in the form reference: Column 6 (Where) [Injury Date] Between [Forms]![ Date Range]![Start Date] And [Forms]![Date Range]![End Date] Also I would slowly build up the Query (add one table at a time) so that you know that the joins are correct and thus the right...

Ok. Here we go: 1. Create a column in Table1 and name it 'Delete' and set to field type 'Yes/No'. 2. Create a column in Dump and name it 'Deleted' and set to field type 'Yes/No'. 3. To Update Table1 with new Table2 data. Copy the SQL below in to a new SQL Window, also add in more fields where...

If it's duplications you are concerned with I would: 1. Insert the data from both tables in a new table. (Use fields from Table 2 to create the new table first). 2. Then create a SELECT Query on the new table, using a 'Group by' on the three similar fields. Add one of the similar fields again...

Right. Here you go: 1. Create a SELECT query and drag both Table A and Table B in to the 'Diagram pane' (top bit). 2. In the 'Grid panes' (bottom bit) in the first column, select (or drag) the field 'Description' from Table A. In the Criteria paste this in: Like "*" & [TableB]![Products] & "*"...

Can you not do this in VBA?

If like you say the Team Member Name in the table 'Team & User Names' are the same and used in table 'Order Data', I would do the following: 1. Let them choose from a drop down - this way you qualify that the name is correct. 2. You can refer to this drop down in yout query in Step 3. Advice...

Not entirely clear on your objective. But why not have two combo boxex on your from that dispaly the church and district instead of text boxes, then when you get to a new record they will just select one from the list.

What is the field and data type for indicating a leaver? Plus do you know VBA? And what version of Access are you using?

1. When user logs on save the user's Dept ID as a Public Variable eg. ' g = global, int = integer gintDeptID = DLookup("[dept_id_fieldname],"tablename","[username_fieldname] = '" & logon_name & "') 2. Create a public function in a module eg: Public Function getDeptID() As...

You should never use hypens anywhere. Always use underscores eg. tblMembershipFee_Category.

You could try this: Add a combo box, the record source being the a distinct query of the dates form this table. Then on Change Event of the combo box try this: Dim strFilter As String 'Check value is selected. 'Write code here 'Apply filter strFilter =...

Open the Properties Window of the Form and check out the Data tab.

You will need link both records. You could use a DLookup on the Open Event of the Report, defining the criteria specifically. Save this in a variable, do the calculation and then display this in the 'text box'.

Hi, I know!...We have an MS Access db in Version 1.x. A word document points to this db for mailmerge data. I've upgraded the version to MS 97 and it works, but when I upgrade it to MS Access 2000/03 it raises the error message 'Unrecognised Database Format'. Error 3343. (I've tried all the...

Hi guys! I have a front-end (FE) linked to a back-end (BE) db. I have added a password to the BE, but the knock on effect is that the FE won't work now. Just says 'Invalid Password'. I'm using MS Access 2002. Any help would be appreciatted. (The password is to prevent unwanted users from...

There are a couple of typos there . . . Try: txtbox = DLookUp("[dunns]","Tblcontractor Name","[ID] = ' " & Me![Contractor Name] & " ' ") or

Do you have it in the Criteria as well as in the list of Query Parameters?? Also Expr1 normally means you've altered a field name somewhere and MS Access (by default) will name is Expr1. Thus check your field references in your query(ies).

Before you open the form you should save all the filter criteria in a string. On the Docmd.Openform command you can pass the string in the Wherecondition. It's just one way of doing it . . .

Could try DoCmd.SetWarnings False/True. Would Seem that your text box is bound?? Would be better to suppress the buttons until data is entered or alter the search criteria. But not knowing your form this is all a guess.