Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: underpaidadmin
- Content: Threads
- Order by date
-
Report/Query Error
I have a monthly report that uses the data from several queries to calculate the data used on the report. Those several queries are all added into one query, which is the actual record source for the report. When the report runs it asks the users to enter the beginning date of the month and...- underpaidadmin
- Thread
- Replies: 11
- Forum: Microsoft: Access Reports
-
Applying a filter on a bound subform based on unbound main form
I am using Access 2002. I have an unbound main form and a bound subform in it. (I mean the main form contains multiple unbound controls, but the subform has a recordsource and has bound controls.) Main Form: frmSearchIt Sub-Form: sbfBrowse What I have been trying to do is take the values...- underpaidadmin
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Search form and Result form
I have been trying to do this for over a week and I just can't make it work. I have an unbound form that users enter searchable criteria into. Behind that form I have VB code to grab all that info and construct it into a query. I have another form which I want to display the results. I have...- underpaidadmin
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Unbound search form, trouble in VB coding
I have a unbound form I am creating to do searches on multiple fields in multiple tables. I have the SQL string stored in a string variable called: strSQL Problem is I don't know how the steps to make that string actually open a form with the results of the query. I also have a record set...- underpaidadmin
- Thread
- Replies: 8
- Forum: Visual Basic (Classic)
-
Syntax error (missing operator)
I am new to Access, VB, and SQL so bear with me a little. When I run the below code it keeps giving me a syntax error, saying I am missing an operator between tblNames.TIN Where Company="Somecompany" Before that error I had an error with having too many characters at the end of SQL statement...- underpaidadmin
- Thread
- Replies: 6
- Forum: Visual Basic (Classic)
