Search results for query: *

len returns to number of letters in whatever you put in the (). if you want the first 4 chars then try left([fieldName], 4)

so, if they are linked tables. You need to drop the tables and relink them. If it is and ADP then check to see if you have limits on how many rows the table can return. Good luck.

why can't you just ctrl-H (find and replace) in the table. If this keeps happening can you put an input mask on the field. If you import the data you could create a recordset that has that character (instr(field, "<") and loop through the recordset by replacing it. If it always is on the far...

set a break and debug. then step thru until you see the message appear. It may not be code but normal behavior. It will show you which step is the last one before it happens, then you can figure out how to stop it.

Tools, Options, Keyboard, Move after Enter. Cursor stops at first or last field.

Either would work. Is this data that they have to enter some parameters to determine what recordset to export?

Why do you need to use a select statement? Why can't you just set a variable = fn_RequestAcessByIDID(1,5) on the form_Open event? Sub form_Open Dim blnAccess as Boolean blnAccess = fn_RequestAcessByIDID(1,5) If blnAccess then me.close else do whatever end if exit sub

if union(rng1, rng2).address =rng2.address then InRange = True End If

You can use the OpenConnection method to open an ADO connection to an existing Microsoft Access project (.adp) or Access database (.mdb) as the current Access project or database in the Microsoft Access window. expression.OpenConnection(BaseConnectionString, UserID, Password) Try this

Have you tried DTS? My favorite website is sqldts.com. I use it to do all of my automated imports. The only time I seem to have a problem is with excel. If you know VB the activex scripts are a cinch. Loop at his looping example, I use something similar for sql data.

try me.repaint

Can they have more than 1 guest per visit? If not, then 1 table for people with a lookup for type (member or guest) or an indicator (bln or member number) and a Visit table with memberid, visitdate, and guest id. If multiple members. same as above but people table, visit table (nember...

Instead of clearing the record, why can't you delete the record and start over?

It is a global variable and I selected date from the datatype dropdown. The value shown from the same form is the whole date. Do I have another option? The most confusing thing is why it won't accept my text. I finally added 2 fields to my import table. In the transformation I assign them the...

On the properties form of this text boxes on Exit does it show the words: [Event Procedure]? If so when you click on the button beside it does the vb window pop up with cursor on the correct sub? If it does then if you put a break on the first line of executable code does it try to run? If...

my statement "Insert Into dbo.tListLogFiles values (5,?,?)" param1 value = "200407060953OpenPTR.csv" (string variable to varchar) param2value = 7/6/2004 9:53:00 AM (date variable to datetime datatype My current status: 2 problems The date will insert but only the date, not the time. The text...

In my DTS Package I have a step that Executes a sql statement: Insert into table values (5, ?, ?). The parameters are set to globals. The first global is a date and the second a text. Upon execution I get the error indicated in the title. I have ran the same statement from analyzer...

btw, I got this code from Sybex Access 97 Developer's handbook. I use it in Access 2002 though. If you need help formatting excel columns and such just execute a macro in excel and copy and paste the code to access. Works like a charm.

I cut and pasted from couple of routines but this is how I do it. I set up a master file with my charts based on a datasource. I do the calculations in access and export the data to the "source" of the excel charts. This is how I do the export. I use arrays for some of the other exports but...

I need to make a choice between a mdb linked to my sql server or an ADP. At the PRESENT time the objectives are to process incoming data, analyze it, and report it (using excel or whatever). The goal is to use Sql Reporting Tools in the future but meanwhile I need to choose. My data is...