Search results

You have a missing library reference Launch your VBA window then from the tools menu select references . Look for the Mircrosoft Office 15.0 Object Library and select it. Then compile your code and that should go away Good luck

Yes, the only thing I can think is that there is a missing library link

put at the top On error goto ErrHand ' this turns the error handling on Code is here then at the bottom on error goto 0 'this turns the error handling off exit sub ErrHand: 'this is the error handler and will give you an error code and description of the error MsgBox Err.Number &" " &...

Hi SiGill it could be that reference to "Microsoft Access 12.0 Object Library" is not set on your database. I had a similar problem a while back on my current database took me ages to find it. Open your database, open any VBA module and select Tools at the top, then select References and tick...

Hi MajP yes you are correct in what you are saying, this was meant as a rough and ready example for a small scale db to get the user started. I use used this approach only on small tables of say less than 100 records anything bigger gives a performance hit on a server thanks for the feed back :)

Here you go I can do the link now https://www.youtube.com/playlist?list=PLYMOUCVo86jEeMMdaaq03jQ_t9nFV737s Cliff

In that code you need to replace EndIf with End If. Don't forget to compile your code as you go and use Option Explicit at the beginning of any form code or modules you write. This tells access that you must explicitly declare all variables by using the Dim or ReDim statements

Everything he does in 2013 should apply to 2016 as well

If you are using A2013 then there is a very good youtube tutorial done by a guy call Steve Bishop it's called Programming in Microsoft Access 2013 and VBA. He gives real world examples as he has been going through major developments. I can't post the link I would recommend you have a look at it

Which version are you using?

Hello How's your VBA skills. You can open a recordset and check if the visitor name is in the table. Try somnething like the code below 'lets open the form find and add the data from my form 'check if the visitor exists Set db = CurrentDb Set Rs = db.OpenRecordset("MyTableName") Rs.MoveFirst...

It also seems to work in A2013 but don't quote me on that. Thanks for the post I can think of a few areas I need to add this when a user enters an invalid value etc

Hi All after trying several methods to link tables I have used a macro that opens the Link Table Manager with a message box advising use. (Not perfect but manageable) however I still have the same problem that the db will not open when the be has been moved/renamed. I get the open database...

Hi I've tried that Access just doesn't open to get that far. The system status says that it is compacting and then closes from what I can see

Hi All I've got a BE db for my front end, I have a splash screen that just shows the db name and welcome message, times out and opens a switchboard. the problem I'm having is that even though I have specified the linked table location as \\server\foldername\subfoldername\BEname.accdb when run...

Hi Everyone I have been programming in Access since way back in version 2 now using 2013. I've have a few years break form Databases but now back in swing of things. I work for a High Speed Video camera company (slow Mo to everyone else) and I'm currently writing a database to handle the...