Search results

Okay, I think I've done enough due diligence to ask this question. I need to know if there is a way to edit a linked table like deleting a row. I've done this to link the table: DoCmd.TransferDatabase acLink I've tried this to set the permission to ReadWrite: Const ReadOnly = 1 Set objFSO =...

Could you please let me know the command to do this in VBA?

Yes, to further clarify, I would like to do that operation using VBA but cannot find a command to do so.

Hmm, just to clarify, I've used Docmd.transferspreadsheet acLink to import the file, and I don't want to insert data into a form, I want to insert the datasheet into the form

I use a button to search and link to an .xlsm file, but after linking the file, I want to import the file into an existing form using VBA (instead of drag/drop into the form). Can someone please let me know the proper command to do this, i have looked everywhere online and cannot find it :banghead:

Thank you for that clarity! This problem just seems so easy to solve. I want to add checked records in subform1 to the table in the subform2 when I click the review button. Could you please suggest a method to do this. Thank you.

I'm not sure what you mean, isn't the strSQL string the: strSQL = "INSERT INTO Forms![Extra Work Report Checksheet]![Equipment Input Subform1].Form[(QuantityUsed[, HoursUsed])] VALUES (QuantityUsed[, HoursUsed]) FROM Forms![Extra Work Report Checksheet]![Equipment Checksheet Table Subform]...

I wish I knew what half of this means. I am familiar with a recordset but am not sure how to manipulate the recordset the way you suggested.

For the life of me I can't figure this out :banghead: I'm trying to transfer records from a table in one subform to another subform (on same form) using a checkbox as a filter: Private Sub TransferAndReview_Click() Dim db As dao.Database Dim strSQL As String strSQL = "INSERT INTO Forms![Extra...

Hey Pat, EquipmentID is already within the two tables (I shorthanded the table fields), but I still don't know see how to use tblEquipmentInput as a UI - especially using the checkbox field as a means to filter which records should be transferred to tblEquipmentTransaction

Hey, I need to use an iif statement to search a field (column) for a certain word. The field is in tblEquipmentName and the input is in tblWorkReport Ex. iif(input from tblWorkReport is in field from tblEquipmentName,...,...) Thank you

Okay, here is the gist of it: tblEquipmentList --------------- EquipmentID EquipmentName EquipmentRate tblEquipmentInput ----------------- Checkbox EquipmentName QuantityUsed HoursUsed tblEquipmentTransaction ----------------------- EquipmentName QuanityUsed HoursUsed EquipmentRate TotalCost...

Hey I have a combobox selection for a field in tblInput where the user can also type in a selection not from the list. When an item from the list is selected other fields in tblInput automatically populate. The problems is whenever the user inputs text an error comes up. To invoke the...

Hey, I've tried to manipulate the tables using a query but I don't know how to make it work for my purposes. I also know there is a recordset solution for my purpose but am not familiar yet with that method. The reason I'd like to copy in parts of a different tables column is so that I can...

Access 2013 Hey, I'd like to copy checked records from one tale to another after a user presses a button. Ex. The table 'Equipment List' has a checkbox column that the user can check off as they scroll through the table on a form. When the user presses a button, after they are completed with...

Access 2013 Hey, I have a table that I would like to contain columns from other tables when the form containing the table is loaded. Example: I open a form to input information into the table 'Equipment Input', but I want Equipment Input to be partially loaded with columns from another table...

Hello, Thank you for taking the time help me with this inquiry. I'm looking to find a means to do a few tasks: 1. I have a table which lists all of the equipment we use in our company and would like to use it as a template in a form so that users can select a checkmark if the equipment is being...

Hey All, I'm a relatively new Microsoft Access user who is happy to have found this forum and am grateful to have experienced users available to help with creating rich databases for work and personal use. I've recently moved to California from Canada (yay, no more winter snow!) and am trying to...