Search results for query: *

Hi All, I have a common problem which I can not seem to stop. after the requery the forms records return to the begining. This is annoying for the users when there are 1500+ records. I need the requery but I can not use bookmark with a requery. The following code is under the command button...

Hi All, I'm haveing real problems using DCount in a text box on a form to count nulls in tblAssigned. I need to count the nulls in the End_Date field. A null means that a contract is rolling and therefore no end date. The expression I'm using is...

Hi All, I'm trying to pass either Greater than 0 or Less than 0 to a query from a combobox on a form. It does not work because the query is looking for <0 as a value when it should be pulling up all negative numbers. The same is happening with >0. My combobox has two values the user can...

Hi All, This is just a general question. I'm looking to integrate my pay and procurement system (which I have built in Access 2K) with a standard pay roll package like Sage. I know there are other packages like Pegasus etc. Has any one done this before and who knows a good pay roll package...

HI I have created a payment an invoice database to take over from excel spreadsheets. The problem is each contractor has a &quot;curent balance&quot; excel workbook. There are 671 work books to import into a temporary table. I only need Sheet1 of each workbook. All the workbooks are named...

Hi All, I have a Tab Control with 3 pages. Each Page has 1 sub form. In the footer of each sub form I have a controll that sums up the Ballance Available (=Sum[Ballance_Available]) Why does this controll not work on the second tab page. All properties are the same as the other 2 subforms. I...

Hi All, I need to convert an Excel expression to work in a Access2k query but its not working. The excel expression in the field &quot;10% Held Back&quot; is: 92%*(6%*(C7-(11.9%*C7))) Cell C7 relates to the &quot;Amount_Payed&quot; field in the Access DB tblPayment. Can this expression be...

Hi all, I think I'm missing something simple but don't know what it is I have a Search Form which has 3 check boxes on it. when a check box = True it passes a criteria to a text box. The text box then passes the criteria to a query. Check box Check_Mob passes >=Date() to [Criteria13] and...

Hello all, If its not possible could someone please tell me :-) I have an Access 2K db which holds consultant, location and project information. Each consultant has a start date and an end date. The consultant will work on one project. There are about 600 consultants and 55 projects...

Hi All, Another cross tab q problem. What I'm trying to do is count how many consultants are working on each project for that month. The query needs to show past months as well. Each consultant has a [MobilisedDate] and a [DemobilisedDate]. These dates could be weeks apart or years apart...

Hi all, I have one query which a management report is based on. The management report has 5 sub reports which are based on the same query. The query has date parameters for mobilised date and demobilised date. When you run the query the parameter boxes for the date input keep appearing about 8...

Hi All, A security question has arisen again!! I have just set up security levels on a distributed Access 2k db. The security stuff is all quite new to me but things are going well so far. However I have a report form where the users can select a variety of reports. The reports open in preview...

Hi all, I have an input form and use validation to make sure the information being entered or not entered is correct. Some of my MsgBox's appear 2 or 4 times before they finaly go away. Why is this? The vb runs On Current so when the form is opened or saved the user gets the MsgBox. I've pasted...

Hi All, I have a subform with a button on it called MakeNote. This button opens a pop up form for the user to enter a note in a memo field which is attached to the consultants id. The only way now to see if the consultant has a note is by opening the form. Is there a way where I can get a...

Hi all, I have a table with [Mobilised Date] and [Demobilised Date]. In a query I need to find all consultants that were mobilised on a project between two dates. For example Between 1.10.02 And 31.10.02. I can do this by either using the Mob or demob field however this only shows consultants...

I have a cross tab query which counts the number of Employed and Hired people per project at each location. If a location has no Hired staff, the xtab enters a column called <> with the values 0. This is good. The same happens if a location has no Employed staff. How can I get the xtab to call...

I just don't get it. I have a cross tab query with one parameter field for location. When I run the query from the query grid the parameter asks for the location once. This is good. However when I run it from the report the parameter asks for the location 3 times. Why is this and How do I stop...

Hi All, Just a quick question. I have a split database on the network. The front end is a MDE file which the users access through a shortcut on their desktops. The backend (MDB) is also in the same folder on the network which users could access. If I lock the backend in a secure file at a...

Hello everyone, I have an Access 2K database on the network with 20 users. The database produces reports already but users are asking to be able to select there on report criteria. I've never done this before so how do you do it? If someone can just put me on the right track it would be...

Hello, I've got a small annoying problem. My company has its own font for writting the logo. The logo is on the top left of all my reports and it is in a label. The logo has only got 3 characters. When I export the report to Snapshot the logo disapears. The logo is fine if I export it to word...