Recent content by nastar1

Excellent advice on the whole. don't be too alarmed at my weekly backup schedule. This is a relatively tiny database and only have about a half dozen or less transactions a week and the total amount of data in those transactions is fairly easy to re-input. I was more concerned with the logic...

Disregard. I simply had a backed up version of the frontend and backends restored and am back in business. Feel free to educate me a bit on procedures I could have followed to recover from this in the future. To clarify, what i had done was delete records from one of my linked tables in my...

I accidently deleted the contents of a linked table. After discovery, I then copied the table contents from a backed up table to the corrupted target table. Now all of my forms that use fields from the affected table are initially blank. Users are able to click the dropdown and select data...

Users are reporting cases where two identical 'SEQ' numbers are being assigned to different records. This occurs when more than one user has the form open to create a new record. My Form_afterupdate code is below: If Me.NewRecord Then Me.FY.Value = CLng([FY]) Me.Seq = Nz(DMax("Seq"...

pwise, No, the file will not open if that corrupted filepath is displayed. I could never determine what the cause was and could find no assistance or info on it anywhere on the net. Oddly, the corrupted filepath would occur somewhere like 80% of the time in my experience. The correct UNC...

pwise, What it does is open a File Open Dialog box that allows the user to browse to and select the file of choice. From my experience it is far and away more stable/reliable than the InsertHyperLink method. In fact, I could not get help anywhere to get the hyperlink method to work...

Hello vlingen, I tried and tried all kinds of variations of the hyperlink commands, but nothing worked. I finally broke down and implemented the Open File Dialog code in the link below. http://www.mvps.org/access/api/api0001.htm This worked perfectly. It looked awful daunting to me, but...

I'm getting closer to a workable solution. On new records the cboOffSym now displays only those entries that relate to the cboOrgID. The only problem is that when I cycle back through existing records, all of them show a blank in the cboOffSymID rather than the entry that was previously...

I understand not using the * in the query, this was the default Access assigned to those cbo's. The common field between the two combo's is OrgID. It is the primary key in the Orgs table and the foreign key in the OffSym table. SQL for the cboOrgID is: SELECT DISTINCTROW Orgs.*, Orgs.Orgs...

I'm having problems getting the correct configuration for this to work. I have a form with a combobox called OrgID and another called OffSymID. At present the rowsource for the OffSymID is a fieldname of the same name from a Table called OffSym with criteria as OffSym.* and OffSym in...

Is there a technique to using the same basic query only changing a parameter each time you run it? Say for instance I am using a query that captures all records from a table with fields: Name Position OfficeSymbol I then want to be able to run the query to select based upon a parameter with...

That was the problem. I've seen nothing in my travels that tipped me off that the code I was using was outdated, but I was not confident it was good logical code to begin with. Thanks for the assist.

The NotinList below worked fine under Access 2003, but 2007 now displays a dialog box "Do you want to save changes to the design of the form "frmAddDelTics" and then the form "frmAddDelCust" opens. I can't see anything to correct and I dont understand what is causing the dialog box to ask if...

Thanks guys. Your solutions worked perfectly. And I'm learning a little with every solution.

Oops, forgot that you were looking to begin the field with a static text entry rather than the Year. Should be a snap to make that correction to my code sample.