Search results

I created a very similar DB as Bob did in the above sample. I like the idea of having a hidden form with the variables I am using Global Variables but when the code breaks I lose them so Bob's way is much better and I will have to change my design to include that. I am having one isssue...

The first step is to make sure that you have all your tables setup correctly. Have you done this? You said list, but do you mean tables? You want to make sure that you normalize your tables meaning you only have fields in the table that pertain to the table you are dealing with. Example...

Nick, If you are looking for advice from an experts, you are getting it! Everyone is here to help and just because it is not what you want to hear, do not disregard their sound advice. It is not wise to reply with snide comments. Obviously, you are asking for help and want to learn so take...

Ugurovic, Have an unbound text box store On or Off and then in the function check to see if resize is on or off and have an if statement to process off if it is on. HTH, Rodger

I did add a password to my backend so no one could get into the back end tables. If I remember correctly I relinked them when I did this. So I set the password on the back end and then on the front end I re-linked. My front end did not have a password to get in, only the back end. Try that...

I do not have a nice guideline, but I can tell you how I do it. I create two database one has APP in the name and the other has DATA in the name. In your case create a new database and but DATA in the name so you know this is the database with all your tables. Once you have the table...

That is what I thought. I have been doing a lot of development with SQL 2005 for my real job. I think I might just take a small database that I has 5 forms and just a few tables and see how agenizing it is.

I just wanted to see if anyone knew of anything out there now that would help in this process? I have a database that I have been developing for many years and really would like to take the next step and move to SQL and VB. I know this will take a long time, but I figured the database has been...

Hello all, I have been working as a contractor for a small company for about 10 years now. I was originally asked to come in and help them with an existing database that was no longer working properly. I was able to fix there issue and over the years have developed the application into a...

At what point do you want to do this? Do you want the user to click on a button when they want to do this? or as a scheduled task?

You want to use DateDiff DateDiff("n",[OpenedDateTime],[ClosedDateTime]) This will give it to you in minutes.

Yes you can do this, but I would caution doing this in word. You will need to run make table queries and then Word will be able to see these tables. Word will also lock these tables so if there are more than one users, they will get an error if they try to open the same Word document. I have...

OK here is my situation I have an Access Database that I store demographic and financial information about a client. I then have several queries that will export the data into CSV files saved into a folder with the clients name. I then have the below code that will look in a folder for the...