Search results for query: *

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.

Julian date is only a 3 digit number starting at 001 every year and ending with 365 or 366. Heavily used in military data systems and calendars. I think you could use something along the lines of the code below. On each new entry, you'll get the Year, then the Julian date and then a unique...

WHen I click the cmdButton with the code below the first time on a new record, the save processes, but the OpenReport does not. If the user clicks the cmdButton a 2nd time, the OpenReport works. Any tips on what I've done wrong in my code so that the save goes and then the OpenReport follows...

Anyone have examples of how to write a WHERE statement with one JOIN in it, that I could include in my OpenForm method? Not sure if that is even possible or not.

qryWAbyPoc is a Select Query and to get the SQL equivalent, I had to export a copy of the documentation. See below. SELECT tblWA.WAID, tblWA.Seq, tblCLIN.CLIN & "-" & tblCONTRACTS.Name & "-" & [FY] & "-" & Format([Seq],"000") & "-" & [Rev] AS [WA#], tblCONTRACTS.Name & " " &...

I have a main switchboard menu choice that would run the following: DoCmd.OpenForm "frmQuickView", acFormDS, "qryWAbyPoc", , acFormReadOnly, acWindowNormal However, the user gets prompted twice for the POC LastName and ultimately no records returned by frmQuickView. qryWAbyPOC includes most...