Search results

Thank you all for the help and information supplied. I'm marking this thread as solved.

Hi Doc_man you may be right as arnelgp does not have the bracket around the "T" &'0000' bit and it works thanks for the insite and the help

Hi Plog I tried separation them, the DMax Worked, the Format seemed to work but no idea why they don't work together. Adding arnelgp's NZ function worked. thanks for the help

Hi arnelgp that worked a treat, thanks very much

Thank you all for the replied, I'll try them tomorrow and get back to you all

Hello All, long time no post. So a lot has happened since I last posted here. I've changed jobs and I'm now in another industry altogether. I'm still putting my Access skills to use here too. I'm using Access 365 which has been a learning curve so maybe that is the issue Now down to the...

Hello All. You wont believe this, I moved the combo box a few centimeters to put another combo box to try something out and the old combo box works as expected. I'm completely lost why that would happen. Thank you all for your help.

I would but it is the design colours for all forms in this Database, it was not my first choice if I had the option. That being said this is the only form that this has happened to, I think

Hi MajP I tried that but I still seemed to get the black text

I tried a new form and the same thing happened, it's got me stumped

or start again

Yes it's a complete mystery to me. I'm thinking of coping the form with another name and see what happenss

Tried the repair - still the same. I've attached a cut down version, Open the Frm_tickets form (ignore the messages) and select from the top "Actions" then "Amend Dates. The Amend TSR is white text When you open the Frm_Repair_Main and click on the Amend button the form opens again but this time...

@DHookom Yes you are correct, I selected the wrong subject area

I'm trying the repair now

I tried a compact and repair still the same issue. I'm doing that now but there are load of unknown variables flagging up as I try to open up the forms I require. And now access has hung on me...Give me a bit to sort out the mess and I'll be back to you

Ok let me quickly make a small DB for upload, may take me a bit

Hi Gasman Office Professional 2013 and is says version: 15.0.5603.1000 I've never come across this before

Hello All I've got a weird issue that I've been banging my head against for the last few hours and it's driving me nuts. So I have 2 forms (Tickets and RMA forms) that call a single form Frm_AmendDate. this form uses a flag set by the other 2 forms to determine if you are changing the Ticket...

oops sorry, got a bit of a cold at the moment so a bit fuzzy with things. It came up on my "See what you have missed" email so I thought I would have a look see