Search results

ok, thanks for the link. I'll take a look at that.

haven't done it in a while, but I think around 60mb

Yes we have compacted it, but it goes back to the 75mb within a week or 2

...if having a library database... ok, way beyond me now lol! We are trying to get someone to take a look at it to either fix it or possibly rewrite the whole thing. - And yes, it houses all our time sheets, client info and just about everything else too. Long story, but it really wasn't ever...

Thanks Banana, I will check that out as well!

yes, all my tables are blue worlds with the arrows. So does that mean they are in the SQL db and just linked to access? I guess I would have thought there wouldn't be as much duplication. My "issue" is that we are on terminal services here and the Access FE is copied locally to each users...

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'll check out those links - Thanks!

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...

anaying flicking lights annoy me so much :p

I managed to work this out. Created it in a report and had to tweak my qry.

I changed this to a report and have the following code in my combobox:Private Sub Command0_Click() On Error GoTo Err_Command0_Click 'Button filters out records depending on the criteria entered in the search fields Dim strWhere As String Dim lngLen As Long Dim stDocName As String 'Stores the...

Not sure if I'm on the right track here, but I have a form that only has a combobox for searching the classname. Then a subform to show the expression. I have 2 problems: (1) the combobox shows 1 class name for each record. The record is a student record, so for each student in that class I...

The query as it stands now has all of our class data in it (1900+ records). I would need a user selection to filter for a specific class: eg: LA-196-1001 (38 records) What is the QBE? EDIT: I have the expression working! Thank you. so basically I need the user selection entry. What I have...

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...

AH, good to know...Thank you for that info!

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...

Closed They are joind by student number. I'm not sure what the problem is, but I tracked down another issue and it is an issue that will sove this problem for me. But it is a data issue. I can get all my info from 1 table, but the table is not complete. So that is a problem for data entry...

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...