Recent content by jamescullis

Spot on MajP, thanks mate

Hi all, I want to rename a table field in VBA after import but I don't know the field name, I only know it's the 4th field in the import xlsx file that changes daily. Any help please?

Hi All, Taking this form to the next level, I'd like to have a combobox and checkbox in the search fields, i've got no issue at the moment in getting the Controls onto the form, its the VBA that isn't working I've manged to get a checkbox partially working (i'm sure its not totally correct)...

HI all, I'm opening a browser at a specific page from the form using the following VBA. Just wondering if I can stop the field from being a hyperlink if the value is NULL? CreateObject("Shell.Application").Open "http:/google.com" & Me.OpenURI thanks in advance.

Thank you Minty and Ridders, spot on. I"ve gone with ridders but you've both given my an excellent answer. Pat_Hartman: my db has 4 entries where this is required, not a big issue, just frustrating

looking for some help, please. I've got 4 fields [firstName] [Firstname_formal] [Lastname] [Lastname_formal] Some users will have a formal name (could be one or both) but prefer to be called something different. John | Soon | Downer | Tzvetozar Pam | Pamila | Downer | Jan | | Smith | Jones...

mate, you nailed it! thank you so much

Hi CJ, I modified the the names so it may make more sense. lets say its a cleaning business where your engaged to clean one or more parts of a house as a "project": floors, windows, doors etc. In some cases on the same "project" you have units, each unit has floors, windows, doors to clean...

Hi CJ, I've uploaded the mockup for you. there are 2 query's - qryMultiCard_working just the basic one which gives me the result you provided - I added one more called Multicard that displays the data as i need it - qryMultiCard_notworking in this query, I added the "AND...

hi cj Didn't spell it out very well then, sorry. I'll prepare one tomorrow.

Hi CJ, hope you can advise, I've added another field which is "optional". The field name is colourID. My problem is that it now returns "0.0" if I use the below code. I've been looking about but can't find the terminology to replace the additional AND, I guess I'm looking for something like...

Hi Gina, just letting you know I'm in the process of writing this from the ground up. Hopefully this will help learn this.

ignore the last post, thanks again

CJ, I've got one more step and that to join the result of RowNumber & TotalProducts into the productNumber we need. RowNumber | TotalProducts | productNumber 1 | 3 | 1.3 2 | 3 | 2.3 3 | 3 | 3.3 1 | 1 | 1.1 1 | 1 | 1.1 thanks for your help!

awesome CJ, on the right track now thanks