Search results

Thank you for all your replies, I could look at syncing the data when connected to the network for one of the databases I was thinking of but it wouldn't work for the 2nd as to get the data each day our staff would have to come back to the office each day which is one of the things I need to...

I'm thinking about a couple of new projects for work for use on site using laptops with touch screens or a windows tablet. There are a couple of things I was wondering if they were possible or not. 1. If an access database is on a windows tablet & a form is being filled in would it be possible...

Thanks for your reply, I know it is normalization & a join is already in place, I need to fill the field for another reason. Any help with the query would be appriciated

HI all, I need to update the ClientName field that is currently empty on one of the tables on my database using the ClientName field on the Clients table, I have been looking online but I'm not sure the best way to do it so any help with how to create the query would be appreciated. Table...

Thank you again pbaldy, it works now

Thank you Uncle Gizmo, I'll have a look at those links

Thank you pbaldy, that works now :) , I just need to figure out the other problem now

I haven't done that before (still learning), unfortunately the database is a bit of a mess at the moment as I am working on rebuilding it & getting rid of stuff that isn't right on there & adding new features, it would take me ages to clear all of the data & images from it. I've just made a...

Apologies, the combo box bound column is the actual job status ("Works Booked", "Quoted", "Invoiced" etc) not an ID field, nothing happens at all when the combo box is updated/changed, there isn't an error or anything like that

Hi all, I'm trying to add a couple of features on one of the databases I built for use at work, one doesn't work at all & the second isn't working exactly how I want it to so I thought I would kill two birds with one stone in one thread. I've done some googling & searched on here but haven't had...

Thanks all, I'll look into adding some VBA code to the fields OnChange event

Hi all, I have done a bit of searching online, didn't really see a what would be the best way to do what I need One of the fields on one of the forms on one of the databases I have created I want to use its contents as part of the file name when a pdf is created, with it being used as part of...

I've tried having them commented out & removing the ' its still not working though, annoying that it isn't working but tbh I could probably do without the search function on the form. Thanks for both your help in trying to fix the problem :)

Do you mean remove both of those lines out of the code?

Thank you @MajP & @theDBguy I've saved that link in my favorites There aren't any errors anymore but the button isn't doing anything at all now

No, its a text field

Sorry, I thought it was how I had changed it, I tried your version of the code & don't get the error anymore, I get a different error when I try & do a search for the number "4421" like in the attached image in the VBA window Me.SubNPUListSearch.Form.RecordSource = SQL is highlighted in yellow

That's exactly how I tried it :rolleyes:

Hi theDBguy, thanks for your reply I was wondering about that & tried changing the 2nd WHERE to an OR like the lines below by still get the error. Is it not possible to use a search VBA code like I use when there are Criteria specified or is there a way around it?

Hi all I've just tried adding a VBA code to a button for searching a subform on one of the databases I am currently building but I am getting the error "Expected: End of Statement " I have used the below code before many times & haven't had a problem before, here is a sample of the VBA code I...