Recent content by ets960

Is there any way to use a select query where it will select the values off of my database but temporarily use a different column name for one of the columns??? I have 3 different item names stored in my main table. When I compare this to another table, I want to select one of the item names and...

I am creating a database that compares different CSV's with the values in the database. It then updates the database depending upon the values in the CSV file. Currently, there are 2 CSV's that we are comparing. I want to make the code more modular so that we can implement many more... The...

That was my first thought on this, I doublechecked all my forms and tables and nothing that I can find that is named "Date"

A quick easy way to do it is to go into the table view and make that specific field required. Only thing is, it doesn't give an error until it tries to save, and then it only says "A required value was not entered" or something along those lines. To get around that, put *s next to the values...

If I am understanding you correctly, you want to take a specific value from the list box, and then run a query on the rest of your records to find all of the records with the same value? I would write an SQL statement and put it in the Control Source. SELECT DISTINCTROW qryContacts.ContactID...

I have a text box inside a subform that I am trying to make it say the current date. I have been also having this same problem at various locations in my program, the users get a compile error, but mine just doesn't work right. Here's what happens: I type in default value of a text box...

That first contact manager that pops up is basically what my contact manager is based off of. The only problem is that it doesn't support multiple users by itself... Thats why I'm trying to see if anybody else has any ideas. Thank you very much for the response though, I appreciate somebody...

I'm in the process of recreating a contact manager for a group of salespeople at an office I work for... What I want to do is be able to consolidate all of the contacts in a single contact database on the back end. Then the records will have specific users specified to each record, and what I...

If the computer you are running it on has Microsoft Access on it, you for sure can run it on the computer. I do that quite a bit, however I'm also curious if you can just put the runtime things on the flash drive to run it... Good question

Thank You!!! Bob- I was having the same problem as the parent, and your code solved my problem also! Thank you very much!

Instead of checking the ip address every time you want to connect, try setting up a dynamic IP address... www.dyndns.com gives you many options. You can download and install a program on your computer that checks the ip address and will change it automatically, and many home routers give you...

Finally got that to work properly... Thanks to everyone for the help, I've never designed an Access Database, and I've never written VBA code before, so I'm just sort of plunging into it. Anyways, to get the integer formatted correctly, I did format(intNewVal, "0000") So thanks everybody

Actually, PrePressNumber is a text field of the format 05-3025 And as far as it being a field name, you're probably right about that... But that isn't where the error was coming from. I updated the code to this and it is working correctly Private Sub Form_BeforeUpdate(Cancel As Integer)...

I keep getting a type mismatch problem at "Year(Now())" at the PrePressNumber line. Now shows up as a correct date/time, but the year(now()) gives me a type mismatch? What is going on??? Private Sub Form_BeforeUpdate(Cancel As Integer) 'Get the maximum number from the MAIN table for the...

Can I do this inside the table by just setting the default value to that function? Or do I have to create some code that will do this in a form? Should I put those extra values inside the MAIN table that I am using (e.g. YEAR and SequenceNumber), or should I create a new table that will...