Recent content by aian
-
A
Solved How can I run this update query without messing everything up?
Thank you, I got it now! -
A
Solved How can I run this update query without messing everything up?
That's EXACTLY what I was looking for! Thank you very much @NauticalGent -
A
Solved How can I run this update query without messing everything up?
Hi @Gasman thank you for replying. I understand the first bit of your answer about the county in the customer table and you are right, no need for that. But I lost you in the second part of your answer. How do I update all the existing entries? -
A
Solved How can I run this update query without messing everything up?
Hi all, I have an MS Access 2007 database where I keep contact details of people. Data is input through a frm_CUSTOMERS and sent to the table tbl_CUSTOMERS which has the following fields: CUSTOMER_ID FULL_NAME (text field) ADDRESS (text field) COUNTY (lookup from tbl_COUNTIES) POSTCODE (text... -
A
Primary key based on field's content
Also, I'd like to add that after the import of the Excel file's contents, there won't be any additional data entered. What enters during the import will be final. -
A
Primary key based on field's content
@The_Doc_Man, thank you very much for the super-fast reply. I got the idea, I'll come back to this thread if I have any issues. Just one question: following this technique, should I also add a primary key as well? Or would the compound suffice? Thanks again. -
A
Primary key based on field's content
Hello to all I have a large Excel file from where I will be importing data to a table. This file has two main categories, COM and RES. Entries can either belong to a COM or to a RES, never both. I am looking for a primary key generated by Access 2010, which will consist of the COM or RES... -
A
Assign values from the last record
It works greatly! Thank you, thank you, thank you!!!!! -
A
Assign values from the last record
Yes, of course. And then I edited the BeforeInsert property exactly as it is said in the page, putting: Private Sub Form_BeforeInsert(Cancel As Integer) Dim strMsg As String Call CarryOver(Me, strMsg) If strMsg <> vbNullString Then MsgBox strMsg... -
A
Assign values from the last record
OK, I replaced it. And when I hit enter to save the change, access pops up an error message saying "the expression you entered contains invalid syntax" I also entered the same without the "=" at the beggining and even though access accepted that, when I tried to use the form, Access says cannot... -
A
Assign values from the last record
Thanks RuralGuy, but in the BeforeInsert property of the form I have already put [Event Procedure] as per the instructions on step 7 of the page article I mentioned. Should I delete that? -
A
Assign values from the last record
I was looking for a way to assign values to fields from a previous record. After trying Microsoft's solution (that didn't work), I searched and found this article which worked like a charm. The only problem is that when I use the code in a form that has had no previous records, Access pops up... -
A
Form to enter multiple entries simultaneously
Anyone with any ideas on how I can do this, please? -
A
Form to enter multiple entries simultaneously
OK, maybe I've found a less complicated way. I can make a form that includes a subform. The main form will always add the person's name and the subform will contain all the rest * ID_APPTS (Auto generated) * DATE (Date) * TIME (dropdown list text such as 08:00, 08:15, 08:30... -
A
Form to enter multiple entries simultaneously
Galaxiom thanks. The client name is already in a different table, I just didn't mention that in my post. If we left VB code aside, is there something I could do using macros? Even if I couldn't do the whole thing, any little bit of automation would save me lots of time. For instance...