Search results for query: *

I have been through several posts on the site searching for a code to count the number of records in a SubForm and display in a field on the main form. There are several posts but they are parts and pieces of bigger code. I wrote a simple piece of code on the display field on "Got Focus", but...

I have been searching posts and FAQ but have not found any solution to an issue I have using the TransferText command in VBA. My code works but the resulting text file I produce has qoutes ("") at the beginning and end of each record. Can I strip or delete the quotes in VBA code prior to it...

I have been out of the VBA scene for a long time and this seems easy but I have been searching the FAQ and other posts since 8:00 am and have not found code that can help me. Any help would be appreciated. I want to populate a field in a table from the data entered into another field in the...

Alright this is going to be a little difficult and I do not know where to start and what forums to use (VBA, Access Forms or SQL) but I believe the answer lies in VBA coding so I am posting on this forum. I have an Access database with a SQL back-end for training function. I had the system...

I am trying to get the same data retrieved for different months, but not sure how to code it. It works fine for 1 month (May in this case) but I need to know if the person made a payment in full for each month for April and June also in one query. Thank you for your time and patience: SELECT...

I am sorry to post a second time but I think the code at the end is close, the error I get is it cannot find my database on my machine: (Msg 911, Level 16, State 1, Line 1 Could not locate entry in sysdatabases for database 'DCSS'. No entry found with that name. Make sure that the name is...

I am trying to copy select records from a table on another server to my local computer using MS SQL Server Management Studio for SQL Server 2008 R2. The table does not exist on my machine and I would like to create and then copy the table structure (indexes, etc.) and table data. I only have...

I wrote a query to: 1. Do not use "Nulls" for End Date, and #2 Give me "Max" EndDate. But I am still get records that the has "Nulls" in the EndDate field, which needs to be excluded. Can somone please look at my code and advise me where I went wrong? Thank you all in advance for your time...

I must be tired and I am missing something in my code, the error I get is "Object Required" on the line. The code uses a form that runs a create table query "qry_SearchEmployees" to create "tbl_TempAllEmployCourse"; then I try to insert into another table the EmpID and CourseID (into...

I am using a form to input data into another table. I wrote VBA code and yesterday it worked fine but when I closed everything out I think the code decompiled or something else changed my settings. I am now getting the error "Run-time error '3622': You must use the dbSeeChanges option with...

I am comparing name data from 2 different systems, the first is in DB2 and the other is a text file. The issue I have is the name (first, middle and last names)have following spaces in the DB2 format, such as each first name uses 20 spaces, so "CHRIS" is actually "CHRIS " with spaces...

I have been gone for a very long time, and thank you in advance for your help. I have a table with 2 date fields I want the latest date to populated in a new field. I wrote a very basic line in the query section but Access does not like my comma that starts my second statement: LatestDate...

I was given an Excel document the shows reservation (client ID numbers) and the number of days stayed (18000+ records). So I have a lot of duplicate customer ID numbers with different number of days stayed and I want to keep the first entry and disregard the rest because the first ID number is...

I have a form (frmICLog) and within this form is a sub form (sfrnICLog) and there is an "AutoNumber" field (ICLogID) that I want to copy to another form that opens on top of the main form (with subform). I want to copy the field (ICLogID) to my new form (frm_Person) that was the same named...

Can I change the properties on a checkbox on a form. I have a form were I do not allow edits, but I need the checkbox to be edittable. I went to VB and tried ActiveCkBx.Edit=True and ActiveCkBx.Control.Edit = True but these are not recognized by any of my libraries. Please help.

I have a field (logs.HourlyRate) I need to copy data from another field (classes.HourlyRate) and have it so it never updates by copying the field again. Example: In 2004 nurses rate is $17.25, this field will need to be captured. On 5-23-2005 the rate is $18.65, but I do not want to change the...

I have 2 fields on my form and I need to calculate time. I have a StartTime (DD/MM/YYYY HH:MM) and a StopTime (DD/MM/YYYY HH:MM) and I need to determine how much time was spent in minutes in a separte field. This is a piece of cake in Excel but Access doesn't work the same. Help!

I want to use a form which has a drop down menu on it to produce a report. Right now I have the basic query and when it is ran the user must type in the Agency name fully and correctly to see the results and produce the report. My plan was to have the form with the drop down of all agencies...

I learned my leasson on being to brief so bear with me. I have 2 tables and each table has a form to enter data. Tables as: (1)CaseID-Key BookNum- Used in several tables Color Size Cover (2)PhNumID-key BookNum- Again PhoneNumbers My database starts with the CaseID form and the user inputs the...

We are getting the follwoing error on PeopleSoft 8.3: "Field does not exist-- Personal_DATA.MILITARY_STAT_GER. At PERS_DTGER_SBR.MILITARY_STAT_GER.SaveEdit PCPC:115 Statement:2" Please help... Thank you.