Search results

If you had done you link correctly, the file should behave like an access table and you should be able to use it as such, including creating a form. I suspect that the link was not done properly. Open your db and on the tables tab, click on the linked excel file and see whether it opens or...

Link the Excel spreadsheet to your database via the File menu in your Access menu bar: - File - Get External Data - Link Once linked, you can treat it like a regular Access table.

Try using DMax to get the last service no. created into your textbox. In the onload event of your form: Me.textboxname = Dmax("[ServiceNoFieldName]","serviceTableName") This should capture the last number created (highest value) in the table.

Try this: In the after update of the login textbox : forms!tagetFormName!loginTextboxName = forms!sourceFormName!loginTextboxName Note: This would only work if both forms are available in memory, ie. you have both of them loaded. This approach would not test the validity of the username...

It is possible to use just one transaction table to record all activities relating to specific inventory items. A simple table would contain the following fields: InventoryID TransactionDate TransactionType In Out You'll need the transaction type to indicate the nature of the "Ins" and the...

I have used the movesize command in the "on load" event of one of my forms. I have also used it in the "On click" event of a command button.

try: DoCmd.OpenReport stDocName, acviewNormal or just: DoCmd.OpenReport stDocName

You can create subreports within a report with each query as your record source. This way they would all show up together in one report.

Assuming you'll cut your lumber into 2 pieces only, I'd approach it this way: Create a form bound to your inventory table, place the following controls: a) combobox to allow you to select the lumber to cut b) text box to display the inventoryid c) text box to display the description d) text...

Item 2) "I have this working and it populates the fields but isn't saving them in the table." ================================================================ If you are able to populate the two fields with values from your two textboxes, you should be able to save it in the table. Try issuing...

One way to capture the user name is via the Environ function. Syntax : Environ("UserName") You can store the value derived from this function in your table. I usually trigger this update via a DoCmd.RunSQL.

Youl'll need to test which of the two forms is loaded. To do this, you need a function in your module. I have pasted here the code which I found by searching the forum: '======================================================= Function IsLoaded(ByVal strFormName As String) As Integer ' Returns...

Your code: Sum(IIf(Right([Dedtype_CD],1)="E",[overded_am],"")) I think the problem lies in the "" - right after [overded_am]. You can not perform arithmetic on "". I suggest you replace them with zero and see what happens. Data type mismatch indicates a certain type of field is expected but...

You're on the right track. In your query design, create 3 calculated fields, one for each deduction type, e.g.: TypeA:Iif([DeductionType]="TypeA",[DeductionAmount],"") Do this for the other two types and you should have these 3 additional columns that you can use for reporting purposes, etc...

Try sorting your record source on the primary key asceding order.

try: "[ReferenceNumber]=" & Me![ReferenceNumber] & " and " & "[IssueNumber]=" & Me![IssueNumber]

Try using conditional formatting in the detail section or your report such that you will make the label invisible if the direct report's name is null or blank.

You need to know what day you are doing the import. Try the following to convert the current date to yield the current day: =Format(Date(),"dddd"). If your day yields Monday, then you just need to subtract 3 from your date to get Friday's date, otherwise, subtract 1 to get the prior day's...

You can issue an sql statement to insert the values coming from the text fields in your form into the new table you have created. Syntax: Docmd.RunSql "INSERT INTO table2 (fieldname1,fieldname2,etc) VALUES (forms!yourExistingForm!textField1,forms!yourExistingForm!textField2,etc)" The number...

After a user has added a name, try issuing this command: DoCmdRunCommand accmdSaveRecord Then do a requery of the combo box. HTH