Search results

if ObjectExists("Query", "qryName") then DoCmd.DeleteObject acTable, "qryName" end if Set querydef = object.CreateQueryDef ("qryName", "sqltext") I guess this is it. Finally found it.

You could ignore it if you don't need it. Just allows you to beable to differentiate between the two, where if you didnt, you couldnt. But if you don't want to, you can exclude it from queries you don't need it in. Just better to have it done now, than if later, if you ever needed it. In other...

Just add another field to the table where they enter their hours, call it "EntryTypeID" (Number) and make another table tblEntryType ----------- EntryTypeID (Autonumber, PK) EntryType (text) and link it using the ID add to this table the following: "Weekly" "Daily" thats it.

Creating a query with VBA Code I am trying to have my program, check for a query, if its there, erase it, and make a new one based on an SQL string. I tried searching for this (tried "vba create query" and "create query with code") nothing came up related to my problem. So here I am...

for calculation sake, have a field that indicates if its a daily or a weekly update. Also, the user should type in SOMETHING to indicate what they did. They don't have to give every tiny detail.

What if someone gets married and changes initials, everything gets messed up. Always use a number. You have a many to many relationship. This allows multiple users per project, which in the next sentence, you say you require. Than you require multiple users per project do you not? Words...

I don't use validation rules, but I imagine the formula would be like this wouldnt it? ([Number] / 16) = (Int([Number] / 16)

I tried putting a rst.close before the exit sub. still errors.

YOU are the "someone else" who is editing the record. (haha, yea I guessed that, not a network database) You say you have a search function. Does it perhaps do a "behind-the-scenes" search by doing stuff with a recordset not visible to the form? (I will post the code) The first 3 entries are...

I still need that window to be part of the other one, or atleast not have to close it down each time.

Ok, it appears that its related to the search field at the bottom. If I take that subform off the main form, and make it its own form, and have it close before I print, it doesn't have that stupid error.

There a way to get more details then that on the error? What forms might be doing it? What part of code if any?

Also, the error comes up twice in a row, then it prints the badge ok.

Removed duplicate customers, still not working. I wish I could send someone the DB, but it has a lot of confidential data =( (house numbers and what not.)

Created a Door Reg Database, basically people come in the door, give their account number and guest names, badges get printed. Simple right? Well, when all the data is in, for the accounts and everything, when I add one customer, it works. WHen I add another, it tells me that someone else is...

Yes, same table. Just have a type flag. IE: tblTrans ----------- TransID (AN,PK) PersonID (FK) TypeID (FK) Amount (Number) TransID PersonID TypeID Amount ------------------------------------ 1 1 1 $ 100 2 2 1 $ 100 3 2...

How did it work out?

So the solution was what i said? heh. Change the regional settings.. ive had it happen a few times.

You will have one table with people tblPerson PersonID (PK, Autonumber) PersonFirstName (text) PersonLastName (text) PersonAge (Number) Then another table with their dates tblPregnancy PregnancyID (PK, Autonumber) PersonID (FK, Number) ProblemID (FK, Number) PregnancyDate (date/time)...

Was it something I said? Honestly, no one is going to build something that complex for you, when you don't know a thing about access. Start simple, learn about it first, then start making complex databases. Its like you are trying to drive a Semi without ever having driven before. I do sales...