Search results

Okay. On a different note (reading your signature), what is wrong with Access 2013? I basically had the same impression of 2010. You can see in my signature that I am still on 2007.

You seem so passionate but I cant' tell why! Are you trying to tell me to do or not do something? Do you disagree with David Fenton? The steps I'm following seem to help prevent corruption. Before I did this, I felt like I was always fighting corruption, though it was probably just bugs and...

Great, thanks. The ribbon table actually HAS to be in the front end. It will not work if it is in the backend. It took me a long time to trouble shoot that issue.

I've been following David Fenton's advice from http://stackoverflow.com/questions/3266542/how-does-one-decompile-and-3-a-database-application thread for a while now. Should I perform these steps on both the backend and the front end? Also, when using the decompile flag, do I need to enable the...

If you pm me an email address I can send you my addon if you want.

Use Dim smith as integer or Dim smith as Long. Interger will cause a problem if you expect the counter to get very large. In that case, use long. If you are not sure how big it would be use long. Be conservative and assume the counter will sometimes be larger than you expect unless you are...

Oh, I just rediscovered that I uploaded the msi instead of the exe. The moderators are hesitant to let me post it for security reasons, so I haven't been able to fix it. I'm planning on posting it somewhere else, but just haven't yet.

But he said he is doing dim smith as counter vba, not sql

I guess you might want to handle that case in your code to avoid this in the future.

Counter is not a data type in access. You probably want as integer or as long. Also, why use variable name smith? Usually people use intI, lngI, or just i.

I think you could make this happen if you know how to write a Windows service. Something that watches for a click of a particular hyperlink. I've never done it, but maybe.

You can try my NavBar addin. I don't know if it works with 2013. It duplicates the navigation bar and puts it on the home tab of the ribbon. It works well, but I do need to make some small changes. edit- here is the link.

But why not make a bound form with unbound controls? Then just set the me!ControlName = me.txtControlName

I tried 2010 and thought it was bad. MS got it right with 2007. Since then, they just change things to make a new product. See my signature.

This is not a union query, so just use the QBE. It will write the SQL for you. Also, I'm not sure that you want the hyphens in your table names.

You've got to write some code. Take the date and time from the user, use code to check the table for that date and time, and respond accordingly.

I'm glad he got his issue fixed, but couldn't he get a reference to the hWnd of the pdf and close it like that? Something like this? I guess he could consider using using a pdf activex control or some kind of reference (if there is one), but I would strongly recommend not doing that.

I will once I duplicate the network. I don't experience the problem when the backend is on the same HDD.

Okay, thanks for the help. If I figure out the speed issue I will let you know.

Im not using it in those queries, it is in the code at various points in the whole project. I am already moving away from using them. Are all of the domain functions not good to use?