Search results

Do a search under Calendar and Datepicker...a number of good forums discussions and examples exist.

1) The code from Gemma is an excellent example that you should use as a model. 2) To see the updated results use the Requery command. Was fishing yesterday so could not get back to you...you may want to post your modified code. By the way, a code window which will retain your indenting, etc can...

Hi, The checkbox error message is coming from the Datepicker. I have to go to bed, but was able to identify the source. I'm fishing tomorrow, so hopefully someone else can pick this up and help you resolve it. Bob

Im not sure if this will fit your needs, but read up on the Union Query, with option all to create a set of records to display on the continuous form. Bob

Line #6 in your posted code is "On Error GoTo Err_Execute". If you place a single quote >> ' << in front of that statement it will read " 'On Error GoTo Err_Execute ". That single quote comments the code line. Currently when an error occurs after that line, the procedure goes to the Err_Execute...

Geroge. we will have to wait for Wilderfan to get back. I think the new database record has a required Yes/No field that may not be in the combo box fields. So when the new record add is attempted, the Required rule fails on the Yes/No field and thereby the combo box gets the weird message. EG...

CEH...right on. Coyote, you may have to create some procedures to convert the 2003 database if you have changed any defiitions. I have a BE version number in the Settings table. When the version of the backend doesn't match the front end, I display the database conversion form which covers all...

A few things ... 1) Your doing a recordset loop and using a sql update in the midst of the recordset process. Personally, I would use the recordset edit....update functions. 2) You are referencing the recordset field value inside the sql...I would use a dim'd value inside the sql statement. 3)...

This error occurs when a Yes/No database field is set as Required ...Yes, this field is part of the Combo Box entry fields, and the checkbox has not been clicked. You can put code in the BeforeUpdate of the combobox field to confirm all the required fields have been entered. Smiles Bob...

Excellent, glad you got it to work. Smiles Bob Sometimes just hearing ideas wakes up dead areas of my brain that should have figured out the answer in the first place. Smiles

Two answers: 1) If you intend to use Access for all future data entry, then the post "Docmd.TransferSpreadsheet allows you to import and export. " is correct, or if your only doing it once ... On Access .... select External Data...Select Excel...and the wizard will walk you through the rest for...

My point was to show how to do multiple lines. I could have added the (undocumented in help)...bold text as well, but that would have been overload. Smiles PS: Do not give up on help.....I find many answers there, and the Northwinds sample database. (I would not code like it is done in...

In General, I agree. In some cases, the Microsoft help assumes the reader has basic knowledge that is not included in the search results. For example the constants like vbYesNo, vbNewLine when entered in the help return no hits. Try using help to find the Dim statement and a description of...

A few things stand out. 1st, you are not checking for a successful retrieval on rs1. If this is a loop, you could be using the first and only successful retrieval in all subsequent iterations. 2nd...you are mixing DAO and SQL for the insert...just different. 3rd...your declaring variables mid...

Wazz that should work, but depending on the records, it may create 2 identical records for each tag. "IF" there are 2 distinct record types, it would be better to build two "make table queries"...one for each record type, then use an inner join on the report to connect the 2 new tables using the...

I'm not sure, I really haven't even looked at the current system. I am developing a replacement for my current application. I simply unloaded the databases to excel and imported the data to ACCESS. Since then I have tweaked the application to run accde, dns and dns-less to SQL Server. From the...

Version is 4.018 or something like that. So that may be part of my MySql trouble. Still, once burned, twice shy.

I will check tonight. I am at home atm...if I remember...so many thing fade with age. Smiles PS: Remember, I have huge complex tables with significant activity. Even with SQL Server, data can vanish, but SQL Sever has better recovery processes. Most lost data, when I track it back, is due to...

I recently went through a sizable evaluation of several of the database products and security tricks and tools. I currently have several very large databases running under MySql. My data integrity requirements are sky high, and with MySql I have found data to occasionally just vanish. My audit...

Smiles. I was part of the Microsoft Access Beta and still have the 5 1/2" flopiess. No drive for them unfortunately. I am new to forums. Hopefully I wont mess up too much.