Search results for query: *

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"...

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...

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...

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...

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...

My code below had been working but something I must have changed has rendered the code below invalid. I now get the msgbox error "file not found" which comes from error trap code I've included. I may not have this code setup correctly. My textbox TaskDescrip is populated from another command...

I'm using the Edit Hyperlink on a form and one user is getting an odd display of ..\..\..\filename.ext when selecting any file from the C: drive. Rather than the full path. Any other selection of a file from a server, etc. returns the full path and filename. This is the only machine that...

I'm finding that after a user clicks a date in the Calendar Control 11.0, the focus goes to the first tabbed field on the form rather than the next tabbed control in order. I'm pretty convinced it is one of the glitches with the calendar control, but wonder if there is any way to brute force...

I have a Customer table that includes a Yes/No field that when checked identifies a customer who is no longer active. On my form I have a combobox bound to a query of the Customer table. I want to limit the names in the combobox to only those customers who are still active. However, I've...

I've used the Hyperlinkpart method to remove the '#' signs so I could perform some string manipulation. After the string manipulation I've copied the text string back to a text box with hyperlink properties set. However, when the user clicks the hyperlink nothing happens. I suspect it is...

I have captured the filename from a hyperlink textbox that has a full c: drive path and filename, into another textbox. This has resulted in a trailing "#" and I'd like to remove it before applying the FileCopy function to it. I think I know how to capture a string extract using the Right...

Users would like me to add a button to a form that would allow them to browse a word doc or other file on thier C: drive and then save it to a network server folder. I presently have a button with a Click event with the following: Me.TaskDescrip.SetFocus RunCommand acCmdInsertHyperlink So I...

I'm trying to open a form to a specific record using an underlying query that prompts the user to input the record of choice. The prompt relies on a contanenated series of text fields. What I am running into is that the user is prompted first for what appears to be the first two...

Is it possible to program the Control Source of a form textbox to display a corresponding value from a table or query that is not included in the Form's recordsource and is dependant upon values in a couple of the form's other controls? My current form is based upon a query of two tables to...

tblWA includes many fields including the following: Originator POC Manager each of those fields were setup using a combobox lookup to tblNames to display the person's name. tblNames includes the firstname, lastname, office and phone. When I create the relationships between tblWA and those 3...

The following SQL query is returning a reject for syntax errror in JOIN. Using the MS example, is not helping me understand if my use of parens are the reason or if I'm using the wrong FROM syntax. Any ideas why this is not processing? SELECT tblWA.*, tblCLINRATE.Rate, tblNAMES.LastName...

I'd like to have a command button on a Form that would generate a Report of only the data for the current record displayed on the form. Could use a kick start in how I should get started. I've built a parameter query that prompts for the Primary Key of a record and am building a report from...

I have a table called tblCLIN with CLINID autonumber as my Primary Key Number text FY05 number (is a dollar amount) FY06 number " FY07 number " FY08 number " Sample table result: Number FY05 FY06 FY07 FY08 1011 $4.01 $4.33 $4.39 $4.46 1012 $1.09 $1.19...