Search results

Ok i did that and am getting the error message attached. it says the file isn't there but it is in my Documents folder Sub Button1_Click() Dim accessapp As Object Set accessapp = CreateObject("access.application") accessapp.opencurrentdatabase ("Documents\test.accdb") accessapp.UserControl =...

Thanks Isaac...do i put that code into a macro and attach it to a button ?

Ranman and arnel thank you both. You won't be surprised to learn that i can't get either suggestion to work (VBA and me are not friends) Ranman...i get an error in the first line which is red. I'm also not sure where to put the following ?. USAGE: OpenNativeApp "c:\folder\myDb.accdb"...

Hi All, I'm using Excel and Access 2016. Is there a way i can add a command button to Excel which opens an Access database at the switchboard ?. I've seen a few threads which have offered a solution but i can't get it to work. Is it a matter of adding a macro to the command button ? Thanks

Thanks Gasman you put me on the right track when you said 'other factor'. I went through everything and discovered that a colleague renamed the unbound text box when he was making a couple of changes while i was away. So i changed it back, rang him and told him he was an idiot, and everything's...

That's the odd thing Gasman....some records are ok but others don't seem to be recognising the fact that there are new entries for 2021 ? I would have thought that the code would govern all records......so if it wasn't working on one then it wouldn't work on any ?

Hi again lads.....sorry for bumping this thread. If it's not allowed then i apologise and i'll start a new one. Everything was working fine until the change of the year.........the txt box which shows the last time the machine was serviced is showing a December date from 2020 even though there...

Ok i noticed one of the conditions was working so i had a look to see what was different.....there were quotation marks around the value in the expression which weren't around the others ?. I never even noticed this and was looking for all the difficult solutions.....never happened before...

That was the first thing i tried originally CJ....not working for me

Thanks Ranman but i don't see an option for conditional formatting in Form Design ?. Am i looking in the wrong place ?

Hi Everyone, I'm using a main form which contains 3 subforms. I have no conditional formatting on the main form itself but i've been trying to use CF on the subforms but it doesn't work for some reason. I know it needs to be done at the control level but that's not working either. All i...

Hi Guys, I've been thinking that rather than strip this database (it really is huge), i'll just move the field in question on to the main form, which will solve the problem once and for all. Thanks again for all the suggestions but i think this is probably the easiest solution. Uncle...

I've had a look at those links Gasman and can't get either to work for me. I'll have a go at stripping the database but it'll be at least tomorrow before i come back with anything.........thanks again for the help.

Ok i've tried the code in the Before and After Updates events of the subform but still nothing. gasman.....this database is enormous and it would take me hours to strip it of the sensitive stuff

Minty....tried the dot but no difference gasman.....I got a message saying 'Variable not yet created in this context'. I'm pretty bad with debugging code so i'm probably doing something wrong

Thanks gasman....i tried it without the checkbox part but the control is just blank in the new record. Private Sub txtDispTol_AfterUpdate() Me![txtDispTol].DefaultValue = """" & Me![txtDispTol].Value & """" End Sub

Hi All, I've got a main form called frm_Add/Edit and a subform called frmsub_CalRecords. The main form provides info about a certain instrument and the subform records every time it is calibrated. On the subform, when i move to a new record i'd like the value from the previous record to appear...

Thanks a lot guys.....most helpful as always Em x

Thanks Gasman....i had it in my head that you couldn't do that for some reason. I tried it earlier and made a copy of an existing subreport, put it into the report i was working on, and took some parts out and it worked. However, when i opened up the subreport which i had made a copy of, the...

Hi Everyone, I've got a report which is based on a risk assessment. The assessment contains various tasks and each task has several hazards. The report works fine but would it be possible to have a summary at the start of the report eg: a list of each task and the hazards contained within it...