Search results

It is possible to link an excel spreadsheet into Access. Once linked, you should be able to treat is as if its a native table ie. append, update, reports, etc.

You can create a query and eliminate the names you do not want to show via the field criteria definition. (e.g. under the name field, enter "<> username"). You can specify multiple names here. This query should now the row source of your combo box. HTH

In the criteria of the postalcode field enter the value "2121" Do not include the quotes.

In the On Current event of your main form, try placing a sub Private Sub Form_Current() Me!SubformName!ControlName = Me.RecordID End Sub This code should fire when you move to a record in your main form. Also assumes you have a control named "RecordID" in your main form. HTH

Are you referring to the combo box widht or the fields that dropdown from your combo box? Your combo box dimensions can be formatted as follows: Widht - controls the width of the box itself List Width - controls the width of the list that drops down Column Width - controls the width of each...

I'm not sure you can generate a report from Access in the format that you want where you are basically splitting the record fields into headings and rows. Normally, you'll have the field names as your headings or columns and record entries as your rows. Perhaps other members would pick up your...

Post a small db with your report design. I'll see if I can make it work for you

Try changing the format of the report in design mode: -double click on the detail section of the report -goto format tab -Set "Force New Page" to None. Not sure, but hope it works.

Try If..Else If clause. Much easier to read and follow as well.

One possible approach: - Create a query using the table where you want to do record searches. In the criteria of the field you want to search on, enter the name of the text box from your form plus the wild character "*" (i.e. forms!formName!textboxName & "*"). I believe this will bring up...

Try: =forms!formName![Start Date] &" to" & forms!formName![End Date] assuming the field names on your pop-up form are StartDate and EndDate accordingly. Also, make sure that your popup form is open while running the report.

Me.textboxname = Me.comoboxname.column(0) if you want to capture the value of field no. 1 of your combobox. You can adjust the code accordingly depending on which column you want to capture. Combobox indexes start with a base of 0, so column(0) is actually field no. 1 in your dropdown.

Try: DoCmd.GoToRecord , , acNewRec

Try this code: Private Sub Source_AfterUpdate() If Me.Source = "Contracted Operator/Agent" Then Me.AgentOperator.enabled = True Else Me.AgentOperator.enabled = False End If End Sub

I don't see why you would have issues relating to the primary keys of the various tables you are linking to, unless they have the same table names as the ones existing in your main db -- which I presume is not the case. FE/BE? - Yes, in so far as the two minor db's are concerned, you would in...

One possible approach is to link all the tables from the two minor databases into your main one. Then import all your forms, subforms, queries and reports from the two smaller db's into your main database. Now, you have all the elements you need in one database. You'll need to redesign your...

Thank you too. Challenge keeps us growing.

Attached is the modified code for your db. I have added a junction query (qryJunctionFASubFA) which became the record source of your form "subfrm SubFA". Examine the code behind the click event of your Activate field. There is also code behind the FAID as well. Let me know how it goes.

Attached is the modified code for your db. I have added a junction query (qryJunctionFASubFA) which became the record source of your form "subfrm SubFA". Examine the code behind the click event of your Activate field. There is also code behind the FAID as well. Let me know how it goes.

I think I found the solution to your problem. I will post it tomorrow.