Search results

in my table i have id column and idsequence column, the id column can have multiples, while the idsequence can't have multiples withing the same ID multiple IE, 5-1,5-2,5-3,6-1,6-2,7-1 etc anyways i have created a query that gets the max idsequence value for a certain ID so that i can append...

Right, well that makes a lot more sense. Now would I set my primary key to the auto number field, or the sequential field? (the auto number having no real purpose other than uniquely identifying record, I think ? )

well, I don't care about the auto number for the ID, but my boss does :( , Thank you for your help though -- BTW i started playing DOOM II again since i saw ur avatar lol

Hi, I want my user to be able to "cancel" his entry. At first I tried just deleting the record they were working on. But that added numbers in the auto number "ID" field, and I also needed the feature for editing, so deleting wasn't an option. As of now I have something that works, but is kind...

Thank you Rich

Just wondering if there is a method to check if a form is open or not ?

thanks Much Paul

At some point i want to change my rowsource to another query and i thought it might be done something like this cboBox.RowSource = qQuery where qQuery is the name of the Query... Could somebody correct my thinking ?

This is what i have now that i moved them into query's, but i'm thinking this isn't how you set them to the rowsources.... Private Sub setSQL() If IsNull(cboCustomerName) Then cboSampleType.RowSource = qSampleSearchTypeWithoutCust cboThickness.RowSource = qSampleSearchThickWithoutCust...

the thought never occured to me....

Private Sub setSQL() sqlSampleTypeWithoutCustomerName = "SELECT tSample.SamTypeID, tSampleTypeList.TypeDesc, tSample.SamID FROM tSample " & _ "INNER JOIN tSampleTypeList ON tSample.SamTypeID= tSampleTypeList.SamTypeID GROUP BY " & _...

yes I am familliar with the column system in Access: My example i was referring to the 4th column. The reason i wanted to do it with other columns was that i needed to referr to data not located on the form anywhere else, and didn't want to make a hidden field just because it looks messy imo...

ok, I guess I'll just do it in the module :(

Well i still need to check for null in the case of the user not clicking on the combo box yet

IIf(IsNull([Forms]![fSampleSearch]![cboCustomerName].column(3)),"*",[Forms]![fSampleSearch]![cboCustomerName].column(3)) brings up "undefined function error" so i'm worried that i just have a simple syntax error :( (Its the 4th column that i want)

Hello, I am using an IIF statement in my SQL criteria, and was wondering "if" it was still possible to reference a column within a combo box... here is one iif statement Like IIf(IsNull([Forms]![fSampleSearch]![cboCustomerName]),"*",[Forms]![fSampleSearch]![cboCustomerName]) I want to refer to...

also try to name your fields without spaces, It saves hastle later on

This is the SQL statement that represents the rowsource for one of my combo boxes... I have 5 combo boxes in a sort of search form where the rowsource of each box is dependant on the value of another box, For example If i choose a sample ID there should only be one value for each of the other...

yes that's exactly what i meant!

well i would, but i am browsing for files, I need the full filepath in my table, but only the filename to appear in the box for selection