Search results

Thanks a bunch, that worked! Slightly related question, so I won't start a new topic, I have a query that runs on ChargerID parameters, is there a way that I could have a button on the Asset form that would run that query with the current ChargerID as the parameter and open the form I have for...

It's the former, there actually is a table that isn't being used in there (it was initially and then I realised that it didn't actually provide any useful information), I'm going to assume that that will be the problem? Edit: Yeah it seems to have done the trick. Many thanks.

I didn't really have any idea what the solution was, I changed INNER JOIN to LEFT JOIN on the basis of something I read elsewhere, I don't know what the difference between the two is. The problem now seems to be that it is duplicating results. Essentially the query works by the user entering a...

And what would the appropriate option be? I've attached an image of the design view of the query that's duplicating results at the moment

Okay, I'm very new to VBA, I get what I'm reading there but I'm not sure how I'd go about manipulating that code to get the result I'd want. As I read it, that code says to open the Employees form at the specific record of Callahan by setting the name Callahan as a variable and searching the...

Thanks, this worked for my Charger Search query but not my JobHistory query In response to the other replies: It doesn't (or didn't at all, in the case of the charger search) show up at all in the queries, even after closing the database down and reopening it. The data is there in the tables...

Simple version: Any new data I add to my database isn't showing up when I run a query. Longer version: I've noticed it on 2 queries. One which is my ChargerSearch query with the field name: ChargerSearch: "Charger ID: "+[Charger_ID]+" "+"Scheme Contract: "+[Scheme_Contract]+"...

I've solved that now I thought I'd renamed it to Billed_MonthBox but seemingly not, it was still Billed_Month. It isn't showing the specified record though, it's showing all the records from the query parameters. Edit: Scratch that actually, it works better as a continous form anyway for...

Ah right, thanks. Guess I'll just have to put up with that then. In the meantime I've tried doing it with my Billing information instead. Private Sub Command66_Click() DoCmd.OpenForm "BillingPopUp", , , "Billed_Month = '" & Me.Billed_MonthBox & "'" End Sub And it returns "Compile Error: Method...

Okay, I realised I was doing it wrong. I actually should have been putting something like this in: Private Sub Command63_Click() DoCmd.OpenForm "PartsPopUp", , , "Parts_Required = '" & Me.Parts_RequiredBox & "'" End SubBut that returns the error: "Run-time error '3831': The multi-valued field...

Thanks, like a first class pillock I was setting it to the Command63 which I've just realised makes no sense now that you've explained that. Cheers!

Ok, so I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record. How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being...

Thanks, I've just got back to building this database after a few busy days so I'm still stuck at this point. I've created a label Command63, a second form "PartsPopUp" which is the same as the original form except I've only got the Parts Required and Parts Used fields on display. Here's the...

Hello, to give as brief of an overview of the situation as possible, I've created a query called "JobHistoryQuery" and a form called "JobHistoryMultiForm", this displays all Jobs related to an Asset and all the information about that job. There are some fields (BilledMonth, BilledYear...

Thanks, I actually managed to solve the problem myself by simply making a query that combined the fields. After an hour of messing around, I didn't manage to click on the simple resolution until I'd asked. Thanks a lot anyway.

Hi, this is probably something very simple that I'm overlooking but I have a problem with a combo box on a form. To give a brief overview I have a "Jobs" table, in that table is a "Parts Required" and "Parts Used" field that is linked to a "Parts" table. This table contains 3 fields "PartName"...