Search results

Hello everyone. I am having a recurring problem when developing my database and was wondering if there was a standard workaround. I have for example a query that i need to display in Datasheet View. Ideally as part of the query i would have one of the fields come from another query that has a...

Thankyou!!! I used option 2 and it worked perfectly for me. (that option was close to what i was unsuccessfully trying to do before i posted the question) (amazing i barely had time for a short meeting and had your response when i got back to my computer!! :) )

I have the following: tblJobs qryJobsWithMaterials both above have a field called JobID I need a query (to be called qryJobsWithoutMaterials) that outputs all the JobIDs from tblJobs EXCEPT the ones listed in qryJobsWithMaterials Been going around in circles for hours, not finding a...

yes, i agree that of course 29MB would not be a problem in itself size-wize. i just found it interesting that every time that back-end stops working, it can be fixed by doing a compact and repair which results in a significant reduction in size of the file (around 80% reduction) i guess i need...

I have been having a problem with by Access back-end part of my company database, maybe someone has an idea of what is causing this and how to resolve it? Here is an explanation/example of the problem: - Back-end crashes, front end cannot access it anymore. - i look at my back-end file...

Hello, I am trying to implement a form that i will use as part of a quotation system. The data displayed will come from a query that filters down by quotation number (selected from a combobox or similar), and orders the results based on a field called RowNumber (I use this field so that the...

I am quite new to the whole Access world, this is my first project in Access (though i have previous programming experience), so i clearly do not know all the the 'industry standard' ways of doing certain things, and sometimes end up with unusual workarounds... but as you said this one works OK...

My objective here is to have the user be able to: - select a PartID from a combobox (this then runs an AfterUpdate event that autofills the ManufacturerID and ManufacturerPN) OR - Select the manufacturer form a combobox and enter a ManufacturerPN in a textbox and if I happen to already have a...

Hello all, thankyou to all the suggestions, i think several would get me there, but in the meantime i found a very simple workaround that works perfectly for me: I made a hidden combobox called comboMatchingID that has my query as the row source, then i use the following code to get the PartID...

i guess that the 2 parameters could be the the sections bold below from the SQL of the qryStockFindMatchingID query? (the other query i tested with that had the error expecting 1 parameter has 1 'referenced filter' (for lack of a better word) so i guess that would make sense) SELECT...

Thanks for the suggestion Namliam This seems to work OK if i use a table (instead of "yourquery"), but when i put in the name of my query i get the following error "Too few parameters. Expected 2" Just for troubleshooting i tried with another query and i get the following error: "Too few...

Hi arnelgp, i have tried that but get the following error: "Run-time error '2465': Microsoft Access can't find the field '|1' referred to in your expression" i have no idea what the '|1' referenced in the error comes from... This is the code i have at the moment as a starting point...

Hello all, I am trying to make a VBA script that will be in the 'AfterUpdate' event of a textbox in a form that needs to get the value from the output of a query and use it further down the code. So i have a query (which works as expected) where the output fields are: PartID, ManufID, ManufPN...

Thankyou for the responses, quick summary of why i have the 7 description fields: I am storing data on various types of equipment. Some for example i have descriptions as follows: Relay: ADesc (Coil voltage): example: 24VDC BDesc: (Contact configuration): example: 4PDT CDesc: (Rated Current)...

Hello all, I have a table that contains a list of materials, with 7 separate fields for descriptions segments. These are called ADesc, BDesc, CDesc, DDesc, EDesc, FDesc, GDesc. I would like to display the combined description into a single field output of a query, so at the moment i have the...

Thanks for your quick response, much appreciated, (i had already tried that but had something else wrong, after your message i investigated more and got it working). On a similar topic, below is a screenshot of my overall relationships: As you can see i already had 2 sets of tblEmployees to be...

Hello, I have a table called tblJobs that contains the IDs that are linked to other tables IDs. Those ID numbers are meaningless to the users of the database, so i would like to make a query (or is there a better way to do this?) to 'clarify' the table of Jobs. So for example if i add the fields...

Hi Gasman, Thanks for your suggestion, i think it will work. I am stuck on the last step. How to a make the delete query WHERE Dupes.ID not in Wanted? I have tried with no success...

Hello all, I have a table in my database that is accumulating duplicate entries. (i am trying to work out what is causing those duplicates as they should be prevented in the first place, for for now i need to be able to delete the duplicates) The table is called tblJobs and has the following...

Hello, I have the following tables: tblJobs JobID ClientName (more) tblWorkMaterials JobID ClientName (more) The table WorkMaterials list the materials used in each project so each entry has an associated JobID (from tblJobs) I know it is not a standard way to do things as it would be a...