Search results

alright, thanks.

for some reason, it didn't like dimensioning cn as connection. I simply replaced cn (in the .open command) with currentproject.connection and it was happy.

I'd like to keep track of how many Quotes are late for statistical purposes, so shouldn't i have a yes/no field in my table to track late quotes? or is that a calculation to put in a query when i need it? if i were to keep track in a table, how do i update that field?

I used the code given here which is as follows: Private Sub MyCombo_NotInList(NewData As String, Response As Integer) On Error GoTo Err_ErrorHandler ' provide text constants to reduce text later and allow for faster execution ' due to added speed from the compilation of...

Here's my code. it's in the afterupdate for both dtQuote_Date and dtQuote_Due_Date: If Me.dtQuote_Date.Value > Me.dtQuote_Due_Date.Value Then Me.chkLate.Value = True Else Me.chkLate.Value = False End If Me.chkLate.Requery the chkLate box never changes. I've...

I know how to have Access create a task in Outlook, but what i don't know is how to connect Outlook to an Access database. Anyone know if it's possible to create a task that includes a button that opens the access database? i want to have access output a reminder, and that reminder to be able...

Changed my mind again. rather than coding all the INNER JOINs that i didn't know how to code anyway, I used the design view for the query and it gave me the following ugly code that works: SELECT qrySrch2.Enquiry_Number, tblEnqrr.Enqrr, qrySrch2.Client_Name, qrySrch2.Project_Name...

I've decided not to go with the listbox anymore because it seems easier to write a macro to open a certain record, than to 'innerjoin' my query to 6 different tables for all my combobox issues......

thanks for the advice. The reason i went with the listbox was that i found some code on this forum for linking to a record with a single click. will that work as easily with a datasheet subform? I'll try that now, as i'm starting ove r with my forms anyway.....

here's a stripped down version including gibberish data. it'll open to the form i'm having trouble with.

Industry_Sector is a standard lookup that's referenced to a table of values. it actually stores a number, but displays a text string which is stored in its own table (tblIndSec), and they're linked through an ID in tblIndSec. when i view the input table, or a form, or the query itself, it knows...

I think it's easier to describe than copy SQL's because i have the same problem 6 time over. the data: i have an 'industry' table that lists industry sectors for reference in an 'input' table as a lookup. of course, each sector has an autonumber associated with it, as a link to the field in the...

Yes. create the button where you want it, and in the on click event, place a code such as: forms!frmName.refresh or is it requery? i'm pretty new to this too, but i figured this may help you. i think that's the right syntax. check in the FAQ on form/subform references. it's really useful for...

I'm having the exact same problem as this person. I looked through 20 pages of threads and couldn't find any help for a list box with more than 2 columns... mine has 12. I guess i'm not as perceptive. I understand i need to include the list of possible values (they're in another table), but do...

Got it: On Error GoTo Err_lstSrchRslts_Click Dim stDocName As String Dim rst As Recordset, strCriteria As String strCriteria = "[Enquiry_Number]=" & "'" & Me![lstSrchRslts] & "'" Set rst = Forms.Enquiry!Input.Form.RecordsetClone rst.FindFirst strCriteria...

Update: here's my current code. Private Sub lstSrchRslts_Click() On Error GoTo Err_lstSrchRslts_Click Dim stDocName As String Dim rst As Recordset, strCriteria As String strCriteria = "[Enquiry_Number]=" & "'" & Me![lstSrchRslts] & "'" DoCmd.GoToPage (1) Set...

I'm using this code to bring up a selected record from search results: Private Sub listbox_Click() On Error GoTo Err_listbox_Click Dim stDocName As String Dim rst As Recordset, strCriteria As String stDocName = "editform" strCriteria = "[field]=" & "'" & Me![listbox] & "'" DoCmd.OpenForm...

It worked for me. you have to set column count to 2. that means the combo will look at 2 columns. if you set the column width to 0";1", that means the first column is 0" wide, and the second is 1" wide... so you see the second but not the first. if you set the bound column to 1, then the...

in the bound column field, does the numbering start at 1 or 0?

Pretty much what i thought. I just know for the first while, during the 'testing' phase, the options i need will likely change, but not very often. is it possible to have one value list take its values from another?