Search results

Foolish me. For anyone who found this post as a result of having the same problem, I'll post the resolution. Create a new table with the same structure, and then copy and paste the records from the first table into the second table (or if you are query proficient, and don't want to waste the...

Hi all. :) I have a form which, when the user clicks "Save" generates (or is supposed to generate) a new record in a series of tables using the AddNew method in ADODB.Recordset. My code is as follows: Set rstInformation as New ADODB.Recordset With rstInformation .Open "tblInformation"...

I realize that this posting is quite old, but as someone searching the forums will likely land on it again (as I just did), and as any good IT person would be remiss to add just one more thought to an already drawn out conversation (not knocking anyone here, I'm making a joke at my own expense)...

Your SQL statement just pulls data for the one record where employee ID matches. You want to use findfirst and bookmark to do what you are thinking of. The problem isn't your original recordset, its that your SQL statement will only display the one record that matches the criteria, which means...

Left to right won't make a difference, it's all in the names and how you call the boxes. Do you have your query running the boxes in a specific order, or are these variables you collect in VBA and trasfer to a SQL statement? If they are running in an access assisted query (i.e.: not VBA) then...

You want to count how many jobs are outstanding? Or you want it to display the jobs which are outstanding? Sounds like you just need to run the query and use "Is Null" as your criteria for the chkCompleted field (or IntWeekCompleted depending on how your data is entered) Is this what you are...

depending on how your relationship is set and what fields you are pulling, multi-table queries can be non-updateable. If you don't find anything under access help check here for "non-updateable query" to see what people in the past have done to solve this problem.

How does your Load_New_Employee_Data function work? Are you working on a filter? It sounds like you are hitting the end of the file, which may be a simple solution depending on your code. Can you post more info here?

Anytime, Maddd0ggg's method is most assuredly simpler than mine, and unless your needs change drastically in the future, will work just as well. Keep in mind that if you are working on a more dynamic form where you may need to have this option available for certain records but not others, you...

in the vba window choose Tools - References and see if there is a check box next to Microsoft DAO 3.6

raj, I didn't get the compile error, double check that your text box for First Name is still named txtFirstName. If not, is your code exactly the same as Neileg's? Secondly, did you enter your birthdate as a string (i.e.: 01021983) or as a date (i.e.: 01/02/1983)? This definately matters. If...

Create a command button that creates a new record and then fills in the values of the fields: Me.Field1.Value = "Value" (if it is a string value) Me.Field2.Value = "Value2" etc. Does that help?

Either store your PersonKey as a variable before closing the first form and then set your ID field equal to that variable when you open the second form, or, if this is not a new record, you can open the second form and have your link criteria be "[PersonKey] ='" & Me.Personkey & "'" (remove the...

Wow, give me a little bit more time to look through it, but preliminarily: You seem to have the basic logic down, it appears to be your implementation that is causing you problems. For starters, you should really try to use delete queries and select queries rather than cmdRecordDelete. Search...

Base your subform on a query that pulls all the records from the join table and only those records from the papers table where the joined fields match (i.e.: join them on PaperNum and PaperID and then pull all from Join and only those fields...). Your query should pull the paper number and...

If you are using a report just View - Sorting and Grouping and then group on the year value. Your query shouldn't have any of the sorting or grouping information in it, you shoud do that from within the report to make the query more universal.

You need to parse the description field looking for the word or words that is/are entered in to your search parameter text box. Search the internet for "parse field access" and then create a way to parse the text field for each word and then search the description field for each cassette to...

Sounds like you have set up your query in a way that looks through the records too many times. Can you post the set up of your query (show us what fields you are pulling from what tables and with what parameters).

search this forum for Security and Username

First off, have a field in your question bank table that lists the ID of the correct answer in your answer bank table. Then get rid of that true/false field in the answer bank table. Now you ahve a direct link to the correct answer for every question. You can use the same system you set up...