Search results for query: *

I am using Crystal Reports 11 with an Access database. I need to pull a district number out of a string field then combine the various districts into a single string in order. Taking the district out of the field works fine. When I take the nth smallest districts, I get: 11, 14, 16, 24, 1, 3...

I'm converting DBs from 97 to 2003. I have one where users typed data into a form that is bound to a table. When they clicked a button a report opened which formatted the data they had entered into a letter. They clicked on another button to print it. In 03 it also has to print on a...

Here's what I have: tday = Format(#7/16/03#, "m/d/yy") (changed from Date() to #7/16/03# to see if that was the problem) wkend = Format(InputBox(Chr(10) & "Enter pay period ending date" & Chr(13) & Chr(10) & Chr(10) & Chr(10) & Chr(10) & Chr(10) & "As MM/DD/YY&quot...

I have a main form with 2 subforms. All 3 have unbound text boxes. The Microsoft Knowledge Base indicates that printing unbound text boxes on subforms is a known bug which apparently has not been fixed. Has anyone found a way around this? My form is rather complicated and I'd prefer not to...

I have a form with a subform. The fields are unbound and values or text are assigned in code. Both forms have letter codes and numbers which show in print preview. The data on the main form prints, but none of it prints from the subform. I tried changing the font and it made no difference...

I'm trying to add new records to a subform. The parent has an input box for a date. I successfully get the max date from the existing records. DtDf calculates the difference between the date entered and the max date. If the max date is < the date entered, I want it to add a new record for...

I've tried both find and goto and get similar errors with both. I've looked at all of the examples I can find and figure out what's wrong. [sadeyes] I have an input box that takes in a number and assigns it to the numin variable. Here are some of the versions I've tried. Unless otherwise...

I'm new to VB in Access. I'm developing a payroll database. I need to total hours in a subform by the type (regular, overtime) and employee (social security number). I've gotten it to total by type, but it adds for all employees and when I add the social security criteria it no longer works...