Search results

I have 2 reports that both have a user input StartDate and EndDate. Both reports use the same date ranges. The both work fine and do report the correct data. I have a report#2 in a subreport in report#1. I think it created a separate query, because I now get 3 date range pop-ups. This in...

I have a vehicle daily log table that shows Van# and Daily Mileage. I am working on a report that shows the total mileage per van per date range like so: Van1 Total Mileage Van2 Total Mileage I'm not sure how to proceed with this. All my attempts so far are not good. All I can get is all...

I am having trouble with this. I have a combobox that you can select: Class 1, Class 2 or Class 3 When you select Class 1, I want a check box turned visible. I have tried various If stmts: Private Sub Combo33_Enter() If Combo33 = "Class 1" Then txtClass1.Value = True Else...

I need to contact a SQL db company in order to possibly reallocate the db size. I have been getting size errors. I would like to find out if this is even possible to do. I have read that it isn't possible to reallocate but you have to create a new larger db and import all the data into the...

I have a statement that calls a certain report. It is working, but I need to modify it for a new position. The code is if the person teaching the class is the president, then use report 3. I need to add an OR if the person teaching is the Director, then use report 3. The existing code: If...

Is there a way to write an IF THEN expression inside a query? I have an attendance table with AM and PM checks. I want to have a result of 0, -1 if both the AM and PM checks are -1. I have this so far, but don't know if it's correct or where to put it so it works, my tests so far have all...

I was trying to uninstall office 2007 trial manually and found a reference that said to uncheck the bindings for Office 12 in Access. I unchecked the office 11.dll by mistake in the available references and I can't find what .dll I need to recheck or reinstall. I looked and don't see Office...

I have a form that pulls classes from a date range. This works good as is, but I need to stop it from pulling canceled classes. Canceled classes can have a status of 200, 220 or 240 The existing code is this: strRecordSource = "SELECT * FROM qryBaModDailyAttendanceSheetsMenu " & _ "...

I have a report that has only 1 checkbox depending on 5 different True/False fields. Is there a way to merge these into that one box? Example: if any of the 5 checkboxs are true, then the report's checkbox will also be true. I am debating to add a new user field to the form, but this sounds...

I need to create a new form in order to add new City, St and Zip to a pre-existing ZipCode table. The front end is Access and the backend is SQL. I was looking at other form and there is code that shows it is adding the new data directly into the sql table. Actual code: Private Sub...

Is it possible to make a backup to be used for testing? I have an Access Front End with a SQL backend. I inherited this setup and have limited SQL experience. I do know that all the access tables/reports, etc. are shared from the SQL backend. I need to experiment with some reporting as it's...

We have a SQL 2000 backend and a Access frontend, designed in-house, but it seems to me that the SQL might not actually be used at all? How do I tell if it really is being used? The Access FE has all the data tables, reports, etc and there is plenty of code in the forms. It seems to me that...

I'm using the code below and am getting a runtime error 3061 "Too few perameters. Expected 1." Error. I am basing my code on this post. I am pulling my email addresses from a query that is filtered from a combobox. Private Sub Command2_Click() Dim rsEmail As DAO.Recordset Dim strEmail As...

I am trying to get a report for copying and pasting text into a different program. The data is all in a query already and I need it filtered based on class name. I also need a very specific format: <firstname> <lastname>@<companyname>@1<faxnumber>; [repeat] Is there a way to do this and just...

I did not see any rules against posting for a job, so if this is against teh rules, please delete and I do apologize. We have an Access front end with SQL back end and the problem was that the system was never truely finished or tested properly. We have an educational side to our company and...

I just found out that this years project wil be setting up a remote office location. There will be about 5 users at this location. They want complete control over all equipment. What they have in place here is Terminal Services and thin clients. Our db is Access front end with SQL backend...

I have an existing qry that is pulling up a student history. I need to modify it so it only shows classes that have been completed. The catch is that this info is stoed on 2 different tables. tblClassSchedule, field:Status tbleStudentHistory, field:EnrollmentStatus Both fields= "900" if...

I have 9 different reports that currently print based upon a program name. The problem is that it prints every record in that category. I'd like to have a combobox for "Name" and have the report only print for that record only. My guess is selecting name, setting that as a variable and then...

I have seen several examples of code referencing Me.objectname. I have never used this and can't find any info on what or why to use the Me.

I have a table named: tblStudents I have a fields named Course and Basic Code Enforcement Within the properties for Basic Code Enforcement, I have this as a Lookup row source: SELECT IIf([Course]="Residential Inspector Multi-Discipline",1,"") AS Expr1 FROM tblStudents; It is also set as...