Search results

Glad to hear it, and you are most welcome :)

Hi, Glad I could give you some pointers, although I think you did most of the hard work!

Try this, sorry I haven't had time to test it: Private Sub cmdCancel_Click() Dim intID As Integer Dim intContinue As Integer ' Error Handling On Error GoTo cmdcancel_Click_Err ' Check for a valid ReservationID. If not found then cancel. If Not IsNull(Me.ReservationID)...

I think I may be out of my depth to answer you're question in detail, maybe somebody else can jump in here? I do know that the form record locking affects the underlying record source, rather than any one specific table. Not sure if this helps, but if the form is based on a query that links...

Hi, There is a workaround for this, which requires a form to be loaded at startup. This also requires a table (in the BE) with a single field, and single yes/no value which indicates whether users should be kicked out of the database. E.g. table name: tblLogOut field name: ysnLogUsersOut...

Hi, Have a look at the following URL, this will hopefully help you to understand record locking: http://www.databasedev.co.uk/multi-user-application-record-locking.html Go to the property sheet for the userform where you are editing these records. Go to the data tab and scroll down to Record...

Hi Nadia, I know the feeling! Welcome to the forum.

Hi, Do you want to prompt the user if they want to delete the record, and then either cancel or delete both form and subform records?

Hi Rick, Greetings from the other side of the pond! There is a wealth of information here, so you may find answers to your questions by using the search tool. If not then there are lots of friendly and experienced folk to help out.

Hi pbaldy, What are the reasons for not using spaces in field names? I know that when writing code you end up having to enclose field names with spaces using square brackets. This alone will become quite tedious over time! I have used CamelCase for field names for a long time, but am just...

Hi, Ok here is the code. I have tried to make the code as generic as possible. The only part you should need to change is the table names at the top of the code. Also you will need to set a reference to the ActiveX Data Objects library file if you have not already done so. If you're not sure...

OK, I'll write some sample code to copy the data from multiple tables in Access to a single worksheet in Excel. Might take a while!

So are you looking to create a table with four fields like this? Employee Name, Date, Expense Type / Sold Product, Amount / Quantity Mark, 1/1/2012, expense: travel, amount: 12.50 Jane, 1/1/2012, product: painting, quantity: 12 The SQL for the union query would be something like this: SELECT...

I understand. Ok a couple more questions: 1: Do the tables have differing names, or are they named with a pattern, e.g. TableA, TableB or Table1, Table2? 2: Do you have the same number of fields in each table, and do the fields have the same name and data type?

If it is a pivot table you are after then it is likely you could achieve the results you are after using a totals and/or crosstab query. Can you explain what you aim to achieve with the pivot table, and I will try my best to let you know if this can be handled by access. It is certainly...

Hi, If there are 16 tables then you can create a union query that combines them all together, e.g. SELECT ... FROM table1 UNION ALL SELECT ... FROM table2 UNION ALL SELECT ... FROM table3 UNION ALL SELECT ... FROM table 4 and so on. Alternatively you could write some VBA code that would export...

Hi, Can I clarify something: 1) Are the expenses and sales in the two tables related (e.g. is there a corresponding sale for each expense and you are trying to link the tables by the common fields) OR 2) The sales and expenses are unrelated and you need to create a combined list of sales and...

Hi, Do the tables you wish to combine contain the same fields? If so there would be no need to create a new table. You could use a union query to join the results from the multiple tables together. So imagine two tables, unimaginatively named Table1 and Table2, both containing the equally...

Hi, I think it is expecting the field name as a string, so try: .Fields("rdate") = ...

Hi, I have just tested this, and the listbox seems to store the null values as zero length strings, so you won't be able to distinguish. You could use an ADODB recordset based on the control's RowSource which will let you evaluate null values. Here is my attempt at an example, although not...