Search results
-
T
Listbox rowsource issue
So I took your advice and pasted one of my queries into query designer in sql view (I think this is what you meant by QBE). Here was the issue: sqlDate = "SELECT azteca_REQUEST.REQUESTID AS Request_ID, azteca_CUSTOMERCALL.DATETIMECALL AS Call_Date_Time, azteca_REQUEST.PROBLEMCODE AS... -
T
Listbox rowsource issue
Mr. B, thanks for the reply and the link. I just have a couple of questions: 1. Since the initial form load sets the rowsource correctly, filling the listbox with the query results, wouldn't that indicate that the table connections are initially working? 2. The other thing that is odd is... -
T
Listbox rowsource issue
I have two tables linked through an ODBC connection. I have a form with a textbox for entering a date and a combobox for selecting one of 7 attributes, and a listbox for displaying query results. I am having a problem with the listbox populating with values when updating the rowsource... -
T
Creating Primary Key value when adding a new record
So I took this bit of code from your revisions: rs.Open _ "SELECT SignMainGeneralOID, InspectionDate, SupportRating, SignRating, Visibility, cgLastModified, SignInspectionsOID FROM SignInspections", _ CurrentProject.Connection, adOpenDynamic, adLockOptimisticI commented out... -
T
Creating Primary Key value when adding a new record
Yes. That makes sense. Please give me a moment to digest and test. Thank you. -
T
Creating Primary Key value when adding a new record
I am afraid I don't know what you mean, which probably means no. I will post my code. Perhaps that will reveal something useful: Public Sub ADD_Condition() Dim maxOID As Long Dim cboSupportRatingTxt As String Dim cboSignRatingTxt As String Dim cboVisibilityTxt As String Dim... -
T
Creating Primary Key value when adding a new record
Hello, I have a table with a primary key field (long integer) that is indexed, and is set to not allow duplicates. I am currently using DMax to identify the highest PK value and am adding 1 to this number. When I try to update the field with this number when adding a new record, I get a run... -
T
Populate Text Box based upon Combo Box Selection
This is also good to know. Thanks again. -
T
Populate Text Box based upon Combo Box Selection
That's the ticket! Thanks for helping a noob. -
T
Populate Text Box based upon Combo Box Selection
Would this method not require the use of VBA? As time has gone on I have been wondering if there is an easier way to do what I need to do. Thanks. -
T
Populate Text Box based upon Combo Box Selection
I should have added this to my last post. The value for the query needs to be dynamic based upon the selection of the combobox. This is what my vba query looks like right now: sql = "SELECT * " & _ "FROM SignMainGeneral " & _ "WHERE ID = " & Me.cboID How do I allow it to be dynamic yet still... -
T
Populate Text Box based upon Combo Box Selection
I performed the "Debug.Print sql" as suggested by CBrighton. I believe this has proven to be useful as here is the result: SELECT MUTCDCode FROM SignMainGeneral WHERE ID = 013224404-1 When running this query on the table it returns an empty record for the field I am trying to extract data... -
T
Populate Text Box based upon Combo Box Selection
I changed the BOF to EOF and added the rs.movefirst. It is returning TRUE for the EOF check, even though it shouldn't be, as far as I can tell. Every entry in the combo box should return something to populate the text box. -
T
Populate Text Box based upon Combo Box Selection
I am currently trying to create a form that will update the text in a series of text boxes based upon the selection of a value in a combobox. All of the data updated is tied to either the same table as the combo box or to other tables in the database tied by primary keys. I'm trying to get one...