Search results

I think the function is most likely overkill and I am not even sure I am going down the right road for what I am trying to do. Basically, when I don't want a user to be able to change the data on a form when they are searching and filtering the form. So I was hoping that instead of having to...

I have two forms where I would like to have the combo boxes and text boxes based on how a user opens the form. Since I have two forms, I thought that I would write a function but I am having issues. First off, I know that my code in the function to lock the text box is wrong, but I can get the...

Thank you, I will start doing that because I always run into these kid of issues when I am trying to write a function using multiple criteria.

Thank you. That solved the problem. What mistake was I making with the " and ' in my original code?

I am working on a database that will be used to keep track of various cable that are used to connect equipment. The cables are broken down in to cable categories and then by cable numbers. And I need to avoid duplicate cable numbers. I have a query that is based of a table called...

Thank You for the help, I was able to get the data imported and manipulated to match the new database.

I didn't specify cascade-delete when I created the relationships between my tables. I've always gotten the impression that specifying cascade-delete can make corrupting the database a lot easier.

I know that I over complicated this a bit but fortunately I am still in a spot where I have imported the data that I need and I could just strip away the data from the tables that I don't need. Then I would have to worry about making sure the records match up when after I do the append and...

I decided to create new tables for a couple of reasons. First, the tables from the old database contain a lot of information that I don't need to import and I thought it would be easier to create new tables with only the relationships that I needed vs importing the data and having to possible...

Alright, I have imported the four tables from the old database that I need, and the relationships are intact. Now I need to manipulate the data that I have imported. Can you give me a refresher on the difference between the a parent table/child table and PK/FKs ? My understanding is that a...

When I import the parent tables, should I import the relationships from the old database or just the data from the parent table?

I am trying to re-create a database for equipment tracking at my work. The problem that I am not sure how to handle is importing some of the data from the old database into the new database. The old database has four tables that I have to get data from but some of the data that I need from each...