Search results

If you're using Quick Reply, you need to click the Go Advanced button, then scroll down you should see the Manage Attachments button.

Assuming you have a valid reason for storing a calculated value like this in a table, then; Write as a new record? Insert Into YourTable(YourField) Select Balances From YourQuery Update an existing row? Update YourTable InnerJoin YourQuery On YourTable.SomeField = YourQuery.SomeField Set...

We can't give you advice on how to set up your relationships without knowing more about your application and the nature of what you're trying to model. Ditto for the Type Mismatch error. Hard to say without knowing the circumstances under which the error occurs. If you want to post a copy of...

Select All tables, check Always prompt for new location, then browse to the new back end path.

You can find some coding examples for exporting records to Excel here.

If you move the location of the back end you can re-link the front end copies using Linked Table Manager.

@Jeff Thank you for the additional info. I will definitely need to do more research on A2013 now. I am curious about what level of control the developer has over the relationships and RI with the back end now being in a true rdbms. Do you manage your own instance of SQL Server through your...

OK dichotomous, sorry it took me a bit to get back to this but here is some food for thought. You're close, but your Procedures table still has repeating fields. When designing tables in a relational database, whenever you find yourself creating fields in a table and you're naming them -...

File is too big to attach here. Sent you a PM with a download link.

Geez, I'm so slow :p

Assuming the PostCode in both record sets is the same format and data type, then import or link the Excel data then create a query of the two record sets using Inner Join on the PostCode field. You can then do whatever you need to with the query results (display it, export it, update another...

What version of Access? If A2010 or later is this a Data Macro? Embedded Macro? What's the context? (i.e. you're running this in the After Update event of some Control on a form, etc.) Can you post a screenshot of your macro here?

Let's say your existing Client table looks like this; tblClients ClientID (Autonumber PK) FirstName LastName Address City State Zip Phone Then you would add a Notes table like this; tblNotes NoteID (Autonumber PK) ClientID (Foreign Key to tblClients. Number - not Autonumber) NoteDate Notes...

No problem. I'll do it tonight when I get home.

No. It makes no difference if the form is based on a table or a query. If you're using a method like that then FormA needs to remain open so the value can be retrieved. If you can upload a sanitized sample db that duplicates the problem I can look into it further.

I did parse that file last night. It's a long list though. It seems to be every person on the face of the planet who has ever directed anything at all in the known history of the universe. Even after scanning through and deleting quite a few records that appeared to have just nonsense names in...

Sounds like there is something wrong with the reference to the hidden text box that controls the link for the second continuous sub form. Check that you have the name of the hidden text box spelled correctly in the Master/Child link property of the Subform Control.

You would still need another table to store the related Notes for each Client. Not sure if you're saying you already have that set up or not. Then you would use a main form / sub form set up where the main form is based on the Clients table (actually a query of the Clients table, since you want...

Have a look at Bob Larson's auto FE update tool here.

Yeah, you could do that. Here is some tested code. It uses the InStr function, so some controls could just have USA or CANADA, some could have USA OTHER or CANADA OTHER and so on. I also decided the Len function would be a better option for checking if something exists in the Tag property, so...