Search results

Hi @plog I tried pasting the code in & it is still only working on the combo boxes, error on the date fields still for me. With the combo boxes when filled & the cmd button is pressed I am now getting a msgbox open up that list what the filter is, once I click on ok the report opens with the...

Hi @plog & thanks for your reply again I take it I had to change to the above on just the lines of code for the Combo Boxes? If so I added that but all three lines are now red & show as Compile error: Syntax error Below is the code in case I have added it wrong Private Sub cmdRun_Click() '...

I have added the other lines & renamed as required, I haven't worked on adding the code to add the code to control the report title yet. The code works fine with one, two or all three of the combo boxes when populated, unfortunately it doesn't work with the start & finish date fields, when...

Thank you for your help & advice @plog

Hi all, We are short a couple of staff members in our office since staff members have left our company, I'm not going to lie but I am trying to import the functions of a database created by someone else before I re-joined the company that we don't have much contact with into a database that I...

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