Search results

Hi There, I am using the product inventory template available in access 2013 as a basis for my database and modifying it to suit my needs. I've successfully converted the tables, forms and queries into a local database from the web version. The only problem is during the conversion it doesn't...

Thanks Minty that fits the bill perfectly. Kind regards, Dom

Hi There, I'm looking for a way to display multiple records related to one ID in a sort of list view. I've seen that you can concatenate records into a layout like this: ID 1: Record Title1 - Record Data1, Record Title2 - Record Data2. But that isn't how I would like it displayed. Is it...

Hi all, Thank you very much for all your help and suggestions. I have taken on board what you have said and have pin pointed what was wrong. I didn't have enough records in the one table (tblKeys) to be paired with a nameID from the name table (tblName). I thought I could get away with a few...

Hi There, I have a form that uses a combobox to filter by name to then show the relevant data in the two textboxes below. Now for some reason when I search for the name of the first record it shows the information fine but if I search for any other name it causes the entire form to go blank...

Thanks static. Clearing all the 'record source' and 'control source' properties has done the trick. Many thanks, Dom

Hi There, I have a form which I use to add stock to the stock table. It uses the following code to do this: Private Sub btnAdd_Click() Dim iCtr As Integer 'Calculates how many entries to put into the table based on value in txtQty For iCtr = 1 To Me.txtQty 'Adds all fields into...

Thanks a lot Minty that has worked a treat.

Hi There, I have a combo box that you select a name in and the text boxes below get populated with the relevant record. To achieve this I have got the following bit of code on the after update event of the combo box 'cboNameLookup': DoCmd.ApplyFilter "", "[StaffID] Like ""*"" &...

Thank you Minty, that works perfectly. Kind regards, Dom

Sorry completely forgot to add the picture. Please find attached now.

Hi There, I have a table that contains every single item of stock and they all have a unique ID. (Table contents can be shown in the attached screenshot). What I would like to do is make a Form Datasheet that shows a summary of all these items. I.e I have around 15 'K120' keyboards in my...

Thanks all for your help. You were right in that the issue was the other computers mapped drive letter was different to the one on my main PC.

Hi There, I have a database that uses the table of another database for the names so I don't get a mis-mash of names across databases but for some reason when I try to do anything in the database that requires the linked table I get an error "'N:\Database.accdb' is not a valid path. Make sure...

Thought I'd better update this as it is working in my database. For the benefit of others looking to implement a similar setup I have used the following code in my main form: Private Sub Form_Load() 'Make the Subform invisible upon opening of the main form...

Thanks Minty, your second suggestion got it working for me.

All working perfectly. Thanks again CJ_London. Kind regards, Dom

Hi Plog, I have taken your advice and added another column to my tblBreakdown called DateDeleted. In my report query it checks to see if there is a date in DateDeleted and if so if it falls within a month from the date specified on the form. If it does it gets reported. The SQL code I have...

Thanks Ranman256, I have created a union query that pulls all the data through but when I add the criteria from the original query that sorted the tblBreakdown by date order I get an error "Syntax error (missing operator) in query (((tblBreakdown.BreakdownID AS ID) Is Not Null) AND...

Hi There, I am trying to generate a report where it shows me data up to a specified date. Currently I have a query that searches a table (tblBreakdown in this case) and produces a report with all data entry's that are equal or before the specified date. Now to the part I can't get working. I've...