Search results for query: *

Hi, I have an Access 2000 project running on XP and 2k machines. I have 3 tables with a related field called ID which has been setup for cascading delete of related recordes. The data is in a number format and is the primary key for each table. I have a main form with a delete command...

I have a multi-version environment that uses Access 2000 and Access 2002. I have a form with a command button which generates a report and Outputs the data to an RTF file. The code works just fine in Access 2000 but it gives run time errors in Access 2002. Also note that the computers with...

OHHH! It sound like it is not saving the record. Double check the record source for all of the controls. First open the form in design view and open the properties for the form. On the data tab make sure that tblSR is in the Record Source field. Next check the properties for the ID text box...

Forgot the thread 702-1021328

One thing you may want to try is rather then using the On Open event try the On Load event. The reason is that the On Open occurs before the record set has been loaded. The On Load event occurs after the record set is loaded.

CJSilver, If I understand you correctly what you are trying to do is base the rest of the forms data on the selection of a combo box. If I am correct the check out this thread. I posted something which may help you. Kevin D.

Try changing the list box to a combo box. That will then only display the item you selected.

Sorry for the wait been busy. Here is what I did. May seam like alot of work but if you do it once it will become almost second nature. I have incorporated this method in many of my databases. The forum may have formated my text a little different then I had planned but it should be close. 3...

Kevin, Wow thats my name too I beleive what you are trying to do can be found all over this forum. I have seen it in many threads but can't remember any of them. I found a thread once when I was trying to filter a field based on a combo box so try searching for that. I put together a simple...

ZmrAbdulla Thank You. Thats exactly what I was looking for.

I will try to explain as best I can I have a continuous form displying multiple records. There is a text field formated for a medium date which displays the date the record was last updated. I want to make it so if this date is 5 days old that the back color of this field will change to...

That is my question. I have been developing a few databases and I consider consider myself to be an intermidiate developer. I was wondering though what is better to use when performing simple tasks such as requery a field on a form or oppening another form. I have been using macros but I have...

After looking for the same thing for a button to undo the record and close the form I found scriverb's idea to be the best and easiest to maintain. I went a slight step furthe though. Instead of making the control inactive I set my command button to be invisible and when the form becomes dirty...

I was trying to get this code to work but get the message method or data member not found. What reference should I have set in the VB editor to make this work.

scriverb, Thanks for the code from before. Although It did not prove to be exactly what I was looking for it set me on the right path. I was not familiar with the SelLenght and SelStart stuff. Ad because you mentioned it I was able to find what I needed. One star to you.

dhookum and scriverb, Thanks for the advise. I quess I'll have to rethink my tables out and create some relationships. A little more work than I was hopping for but I beleive I can handle it. Again Thanks.

Thanks Bob I'll give it a shot and let you know.

Thanks Roy-Vidar I'll give it a try and let you know.

I have a query which pulls its data from a table. The table contains several fields which contain lookup values. For simplicity purposes I will keep this down to a few fields. Table1 = tblCustomerData Field1 = IssueID - primary key Field2 = CustomerName Field3 = Owner - The owner is based on a...