Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: HBWAL
  • Order by date
  1. HBWAL

    using the len expression in query pane

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

    Ridiculously Simple Relationship, But It's Not Working!

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

    Update Query to delete partial cell data

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

    &quot;No Current Record&quot; Msg Box

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

    Stopping a form from advancing to the next record

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

    invisible access

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

    Call a stored procedure using a module

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

    error in code

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

    open external database

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

    Automate import of ODBC (SQL) Data

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

    Code ONLY works w/ctrl+break in debug mode

    try me.repaint
  12. HBWAL

    Keeping track of guests

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

    really stupid ? re: clearing a form w/ a &quot;required&quot; field

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

    Invalid Character value for cast specification

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

    Cannot run code

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

    Invalid Character value for cast specification

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

    Invalid Character value for cast specification

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

    Exporting to excel and formatting

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

    Exporting to excel and formatting

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

    ADP or MDB

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

Part and Inventory Search

Back
Top