Recent content by ChrisHannah

hello thanks for the response, i think it was a creation thing... when i created a new form automatically it did not happen so i sumise that it was because the data used to be held in the one table but it was then moved and the links updated but something was still wrong, i have re-created...

hello i'm getting an "operation not supported for this type of object" error when Pressing the Save Button on a form (this doesn't stop the save function) This form has a query behind it that limits the list to a selection and that saves data to two tables tables. i only get the error when...

hello thanks but i am using auto number primary keys for each field that is created, just to explain.... I have a form that creates entries in the table "campaigns" for each campaign there is an excel file with 30-40 peoples names on it. I am importing the Excel file with those 30-40 entries...

Hello I need to set up an event and have people upload a list of attendees each time they fill out my form for this event, they will fill out a form and then select a button to import a spreadsheet. I need to have the primary key associated with the event that i am creating be assigned to...

I have Added code to the open form event that Refreshes the linked tables, it seams to work well with one issue Private Sub Form_Open(Cancel As Integer) Set dbs = CurrentDb For Each tdf In dbs.TableDefs If Len(tdf.Connect) > 0 Then tdf.RefreshLink End If Next End Sub When that loading that...

Hello I have a few issues with the users of my database. When opening the database(i load a menu with 4 buttons on it based on macros) they get a white screen and nothing opens and access goes into "not responding" mode after 2 seconds. 1. if i give them the database with no menu they can...

The Plot Thickens, it appears that my DB is still using local DATA and not the published data on sharepoint (i discovered this by renaming one of the backup data files i had been using previously) Do i need to Re Create All My Queries or something to use the new tables even though they have...

Hello I have a DB that is hosted on sharepoint when i open it it opens fine and i have no issues. when i shared this with my collegues it does not open and simply shows the access window (like you hadnt asked it to open anything?) i've checked permissions to sharepoint and everyone i have...

Hello I have Three Tables related to this output one is customer this is my customer list this is not related directly to the others but there are unique relatable values between these I use an input form to add sales reference numbers to a customer these are kept on a separate table...

is there a way around this, i have a rather complex query because i need to take values from multiple comma seperated inputs and compare that to a list and return a set of values

hello Thanks for the reply, i have linked the child and master and this is what causes the issue that i have (i have linked these child and masters on several other forms so i know how to do it i just do not know why this is going wrong. i had this working previously but had to set a secondary...

Hello I have a sub form that lists the particular purchases made by that client on that clients page. This does not work (except for one result) i have a form that i select my sales lead this inputs into a customer query that filters the results by sales lead this outputs to a form this form...