Search results

You will still need a macro called auto exec to call the VBA code that you want to run on start up, so in the auto exec macro, enter the line Run Code (Function Name Here) and that will then call the function you want. You have called it AutoExec in your code above, i would personally change...

When using barcode the device is configurable as to the behaviour of what it does once the barcode has been read and what it sends to the computer. I used bar codes in my system, and the reader sends through an "enter" press once it has read the information. I would have a barcode for each...

I have a report for stock allocated to engineers. There are several nested groups within the report for engineers, stock item, condition, type etc. I have no problems with the report, everything populates fine etc. but on thing that is annoying me is the alternative row colours. I would...

Just as a thought another way of doing it, but it doesn't involve VBA. Is this just a one off thing? You want to get the data out the memo field and use it, rather than something that you will need to be able to do time and time again? If it's just a single use, then you might be easier to...

Solution found.... Amazon AWS RDS MySQL DB, with 20gb if storage........ free for 12 months! Result

I need to create a database for a charity that I run. We have a version at the moment, but it is just a standalone with normal Access tables. What I need is a split database, with a MySQL or similar BE and multiple front ends I can distribute for other people to use. The problem is that...

I've tried it with dynaset and the rsupdate.edit and it throws an error about me and another user updating the same information at the same time and won't update it, so I tried the code way instead. But that doesn't work either, come up with error about lock violation.

Hoping someone can help here as this is driving me crazy now. Have the below code, top part which is commented out works absolutely fine, is just commented out so it doesn't run for the moment when I am testing the second part. Every time it runs, if I use .edit with the recordset I get an...

I can throw it in there, but the only place that doesn't have it already is where it is working absolutely fine, it doesn't fail until the Select Case statement, and then only on the second time of calling, and .activate is in there, it goes past the .activate and fails after it.

I have modified the code now, and it's requirements, it now runs for more reports each morning, and a specific one on a Monday morning. Everything was working fine all last week, until it ran this morning for the extra report, then I had a similar problem with it. All the normal reports ran...

Is deleting the right option? I find it fairly final and once confirmed it can't be undone. What happens if someone deletes the wrong record? You can't bring it back. What I tend to do, is have a field in the table "isLive", default is 1, then instead of deleting records I mark them as isLive =...

I tried something similar to this a while ago. I recall having to find all the accounts available, then set it to the one i wanted, not manually. It never did work too well, so I scrapped it and sent it from the default instead, and where needed set the return to address instead. I will have...

I have the following sat in it's own module. Option Compare Database #Const LateBind = True Const olMinimized As Long = 1 Const olMaximized As Long = 2 Const olFolderInbox As Long = 6 #If LateBind Then Public Function OutlookApp( _ Optional WindowState As Long = olMinimized, _...

try If Not nz(ctl.Value) = nz(ctl.OldValue) Then

I've got some code i use that does exactly that, checks if Outlook is open, if it is do nothing, if its not then open it. I will dig it out in the morning when in the office and post it up for you, solved a problem I was having causing a crash if outlook wasn't open when the system tried to...

Few problems in your code: YearOfLastSH = Left(Forms!frmNewContract!subLastIDnumber!LastIDnumber, 2) If YearOfLastSH = Null Then Me.IDnumber.Text = CurrentYear & "-0001" End If Even though you check if it's null later in the code, if the control you are referencing is nul it will...

Use a normal autonumber ID field for the record ID to make life easier. If it were me, I would just use that as my ID number, but if you want to keep it your way, then use the autonumber, and then do the following. Have a field in the record for the date it was created, or received...

Thanks, this has been doing my had in since yesterday afternoon you are all life savers. With regards the relations, when I first started doing these, I used to set them up as I created the tables using the relationships tab, but then for some reason stopped. I always have the intention of...

Changing the join to "Include ALL records from 'tblClient' and only those records from 'qrypercentsitecomplete' where the joined fields are equal" solved the problem instantly. Joins is something I really need to get my head round properly as I have never looked into them much, and I can see...

Zipped version is attached.