Search results

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...