Search results

font size Yep. Don't pay attention to the drop down box for Font. Simply remove what is there and type in 6 and hit TAB. It will allow size 6 for instance.

Backup One of several ways is to use the FileCopy command.

label report Morning, If you are using a query where the expression is called name:[firstname] & " " & [lastname]...this will give the problem you are seeing. Call it something like fullname:[firstname] & " " & [lastname]. Interestingly, I have only seen this in label reports. Hope this helps.

Excel Form Don't know if this is what you are looking for, but...This was developed a few years back for a company I worked for which is no longer in business. It uses a form for input of data in Excel. It also does searches. Hopefully someone out there can use this.

Bad access I have seen this before with tabbed forms. Every now and again Access loses it's mind with tabbed forms. Solution: I created a new blank database. I exported your tables and query to this new database. I created a 2 tab form and then copied and pasted your existing fields from your...

Runtime Version Terminology I should have used Runtime Version instead of stand alone. Even after all these years I still slip that term in there from time to time (thanks Pat). However, the Developer Version 1.5 will do exaclty as stated. It will allow you to distribute your program to...

A little more information would be helpful. Is each person going to be on a computer answering these questions? I take it the questions will be setup on an Access form? So, Yep..it's possible.

Report How are you going to control your data and put the values in your Jan05, Feb05, etc. across the top of your report? I think you are going to run into issues trying to do it like this. If you want it to look like Excel why not use excel? Don't know what you are using as your Data Source...

Split Database If you want users to enter data that will be stored in one location (preferred method) split the database using the Database Splitter in Access. By doing this all the tables will be placed say on a server (let's call it the S: drive). As each user enters their data the table(s)...

Query If your total Cost field's calculation is set in a query and your form has it's record source as that query the result should be automatic. If not, you may have to fire off that calculation in the After Update field of a couple of those text boxes...but the calculation in the query itself...

tables I would have split the database. Put the back end on a server and the front end on each users computer. If in fact each user has their own set of data tables on a local drive you will have to apend those tables into to a master table.

Citrix At a previous job the compnay was on the Citrix Neighborhood and did have an Access database on it which users would use..but not as many as 20 people. This was controlled by a contracting company so I can't give you any specifics...just know that it did work.

Access 2000 Minxie, If you have the developers Edition (even 1.5) you can make a stand alone version of your database.... One of my computers at home has version 1.5 and in fact the Package Wizard does exist. After the Packaging and Deployment Wizard is installed from the Microsoft Office...

Huh? Huh? Do What?

runtime I have written programs using Access 2000 version 1.5. At work we have 2003 developer extensions which we use to make a runtime version of programs written in 2000. Was is it you need done? Not interested in the hiring part since we may be able to help through this forum. Yep...

report Group the report by name using header and footer and add the absenses, etc up that way. In the detail section place the absenses field, then add a text box, set it's source to absenses and Running Sum to Over Group.(call this text box text10). In the group footer add another text box and...

Db Hope this helps. See attached

That's because in your report you are grouping by Booking Date and you have two dates that are identical. You have your data in the Header of the report. Keep your booking date field in the Header and then copy all the fields in your Report header into the detail section of your report and you...

What the? If in fact you have records in a table(s) like Rich asked...... I dealt with this issue a few days back with an individual. I had him post his DB but I was able to see fields in queries and reports where he could not. I had him send me a screen capture and yep, there were no fields...

query Your query (Kunder och telefonnummer)is looking for [Forms]![Huvudformulär]![Text10] for it's criteria for Kundnamn. You must have your form (Huvudformulär)open to run a report that uses that query as it's record source.