Search results

I have a button which opens a report and filters the report to show only records between a date range which the user chooses by typing a date into two edit boxes called "start date" and "end date". The VB for the button is: Dim stDocName As String Dim stAcView As String Dim strWhere As String...

Could someone please tell me the format for the SWITCH clause in an SQL statement. And also where the SWITCH command goes within a SQL statement. I cant find it on the net or in Access help! What i am trying to do is take a number and turn it into a string without changing the orignal data...

I can create a button which opens report and filters the data using the 'Where' parameter of the DoCmd.OpenReport function: example: Dim stDocName As String Dim strWhere As String strWhere = "[Date] Between #" & [start date] & "# And #" & [end date] & "#" stDocName = "Trend...

Is it possible to have the deafult value for a field be set to what ever the last records input was. eg. if i created a new record and selected "Smith" as the value for the name field, then created another new record, the default value for the name field would be Smith. Therefore all new...

I am developing a database using Access 2002 set to use the Access 2000 file format, however the target machine which the database is for use on has Access 2000, but different MDAC versions. The cause of errors is the MS Access 10.0 Object Libary. The target machine has MS Access 9.0 Object...

I have a message box pop-up on the before update event of my form. Only problem is i use a tabbed object with 3 tabs, the fields on one tab and two sub forms on the other two tabs. When i move onto the tabs with the subforms the on update event is triggered and the pop-up displayed. Does...

I have Access 2002 (set to use Access 2002 file format) and when i export as Access 2000 and use the exported file with Access 2000 there are many errors with certain commands. Date() does not work, changing to Now() fixes the problem. Left() does not work. eg. Left([gender]),1) gives M or F...

I have tried and tried and now i must try the forum :) I have two tables which are linked with an ID field. In table 1 the ID is an autonumber, in table 2 ID is a number. All records in table 2 that are related to a record in table 1 have the same number in the ID field. I can append each...

Which SQL function is used to calculate the frequency of a paticular number in a number field. I have tried both count and Dcount but dont get the exact results im looking for. Using count i get the number of records, but not the number of records that contain, say, the number 9. Using Dcount...

I am running into a of confusion with an append query. Basically i have a master database (destination) and many data entry databases (source). All the data from the data entry databases needs to be imported into the master database. I am having trouble specifying where the data entry database...

I am trying to design a update query that will rearrange the values (a range from 1-4) in a field in reverse order. So 1 become 4, 2 becomes 3, 3 becomes 2, 4 becomes 1. I thought the way to do this would be to create an update query with the field in 4 times and the criteria for each goes from...