Recent content by HBWAL

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...