Search results for query: *

I have an access table with a field "period" of Text data type. I have to retrieve records from the table between 2 periods using a select query. For retrieving records between periods 1 and 3, When i use "Between AND Operator" in query, then it returns all record which have...

Am very new to Autocad. I need help on how to refresh or reload an Autocad Drawing. The Autocad drawing displays or gets data from an Access database. I run a Macro once the drawing is opened whcih asks for a sheet number using a form. When the sheet number is provided the corresponding values...

How can i specify that the first 2 characters of a Date field in dd/mm/yyyy should be 01? Am not sure how to do it either using Validation rule or by input Mask? Please help. Regards, Charley

I have the following code attached to a button on a form. Am getting a syntax error. Can anyone help me? Am very new to VB. Private Sub cmdExit_Click() ThisDrawing.Input_mas_tag (txtMas_tag.Value,txtMas_tag1.Value ) End Sub Regards, Charley

Hi, How to subtract 21 days from Today's date? I tried something like DateDiff("d",Date(),21), but getting unexpected numbers. Regards, Charley

I have a report in the following format. Discipline Header Category Discipline footer TOTAL eg. A11 CIVIL AND STRUCTURAL ......................... ENGINEERING 10 ......................... .....DRAFTING 10 A11 CIVIL AND STRUCTURAL TOTAL 20 A11 CIVIL AND STRUCTURAL is the Discipline Header...

I have a table field "kstsrt" with values like A00,A01,A02.......A99. I want to create a report and in that I Want some of the values to appear as grouped. ie say A11 and A13 should appear as A11+A13. similarly A71,A72,A73 should appear as A71+A72+A73. The rest of the values should...

Am having a main form with 2 subforms. subform1 and subform2. Subform2 records are based on subform1 records. The users make entry in subform2. I would like to have the cursor positioned on the last record on subform2 instead onthe first record. The same even when the user navigates through the...

Apply filter not working in Access 2000 Hi, I have converted my Access97 db into an Access 2000 and encountering problems with the apply filter method. I have a form which is based on a query. There are a couple of combo boxes on the form. What i do is filter the query based on the values...

Data type Mismatch error! Hi, Am getting data type mismatch error when i select a value in a combo box. When a value is selected in combo box it should open another form depending on the value selected in combo box. The corresponding data type for the value in the table is Text. If the value...

Hi, I have 3 tables 1. Project 2. Category 3. Entry Table project have project no, Project description and client Table Category have Faxes, letters, Transmittals Table Entry have Subject, Addressed to, Date and Remarks 1 project can have many Categories, 1 category can have many entries...

Hi, I have a form on which there are 4 combo boxes. Office, Department, Employment type and function. The purpose of these combo boxes is to apply filter to form data. I have created a Macro to apply filter. Infact its a lot of if..then..conditions checking for which combo box has value and...

When i converted an Access97 db to 2000db, a macro which i created to requery records in a subform datasheet is not working. Am getting the error message "you can't use apply filter action on this window" The same db is working perfectly in Access97. Requery is important since its on...

Am using Access2000. Can anyone help me on the following regarding table links? while quitting a database Is it possible to check whether any linked tables exists in the database and if so delete the links? I am using the toolbar "Linktables" on a form. If the user wants to link...

Hi, I have an address field on Report. The users pressed "Enter Keys" while entering address in form. Presently the address appears on a text box in different lines in the report. Is there any way to make the address to appear as a single line in text box? I.e. combine address line1...

Does anyone have a procedure for prompting a user to select a back end to connect to with tables linking at runtime? Regards, Charley Thomas chthomas@tebodinme.co.ae

Hi, I want to do a simple leave calculation program and show the result as a graph(Something like timelines). The input will be made using a simple form where one selects the employee and then selecting a "Start Date" and "End Date". An employee can take leave several...

I have a a table called "Contractor" with fields "Contractorid" and "Contractor Name". There are many contractors. There is another table called "Section" with "Section id" and "section name" fields. The sections are SECTIONA...

I have to develop an Access program for evaluating the results of a questionnaire. I need some help on the table structures. The questionnaire format is as below Section A 1) HSE 1.1) Question 1 1.2) Question 2 1.3) Question 3 2) Availability 2.1) Question 3) Arrangements 3.1)...

Hi, i want to record a macro in Excel such that after selecting a cell, i want to run the macro which should delete all the columns after that selected cell and all the rows below the selected cell. How to do that. Any help will be appreciated. Regards, Charley