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!

  • 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: xweyer
  • Content: Threads
  • Order by date
  1. xweyer

    Problem Using Variable as Field Name with DAO Recordset

    This code is intended to pull the data from T_LinkedTableInfoCFC (and ultimately other tables of the same design) and compile its contents into T_MasterLinkedTableFields. To process all the fields the code loops through the "Master" table and extracts the name of each field. Everything works...
  2. xweyer

    Bizarre Behavior in Simple Combo Box

    I wonder if anyone has any idea what could be causing this. Basically all the code below is designed to do is to populate three controls (text boxes) assigned to fields when the user selects a name displayed by the combobox (cboConsumer) which it does BUT--- If the user begins typing a name...
  3. xweyer

    Is it Possible to Pass a "Text" Parameter to a Method Via a Variable (without Quotes)

    Recently I created some code that used DAO to read table/field information contained in a table I'd constructed for that purpose in order to append a number of new fields to their respective tables elsewhere in the database. For example the source table for the table/field information works...
  4. xweyer

    Access 2003 Report Hangs on "Formatting Page" in Access 2010

    I have a report that runs perfectly in Access 2003 but when I attempt to run the report in Access 2010 it hangs displaying a "Formatting Page" message. I've checked the libraries references etc. and they are correct. Any ideas what might be causing this?
  5. xweyer

    Problem with Syntax of DAO Findfirst Function

    I'm having a problem getting the syntax right using the Right function with a variable in a DAO recordset using the FindFirst function. Here's the relevant lines of code. The field [Sn_Scan] is text Dim intSnGuessLen As Integer (1st Version) rst.FindFirst "Right([Sn_Scan],6) ='" &...
  6. xweyer

    Find Record Combobox - Strange Behavior

    I have a tabbed form "Master_Customer". There is form to add customers on one tab and a form to add customer's accounts on another tab. After adding a customer on the first form I want to able to add their accounts on the other tab/form. The problem I am having is this. After a new customer...
  7. xweyer

    Network Problem - Slow Wired but Fast Wireless

    Here's the situation, a friend has a small office network that recently converted from one internet provider to another. They currently have several PC's and laptops on the network. Since the conversion any wired workstation is 3 to 4 times slower in accessing the internet (as seen in both DSL...
  8. xweyer

    Save/ Rename Form

    Is it possible to save and/or rename an Access form using VBA? I was considering the possibility of creating a 'template' form which would have particular control properties modified (via code) based on specific conditions and then saving the modified form under another name for later use...
  9. xweyer

    Unknown Jet Error with Function

    I'm having a problem that I can't figure out. I've managed to pair it down to the bare essentials below. In a module I have a public function and variable as below. Public strObjName As String Public Function GetObjName() GetObjName = strObjName End Function In the On Click event of a...
  10. xweyer

    Any Means of Extracting User's Novell Group?

    I know that the WNetGetUser() function can be used to determine the Novell User Name using VBA. Does anyone know if it is also possible to also extract the user's Novell group and how to do so?
  11. xweyer

    Updating Grouped Records by Selecting One From Fom

    I have a continuous form based on a query. Here's what I'm seeking to accomplish. I want the user to be able to scroll through the records and select any one for further processing via a check box. However sometimes a single record is part of a larger group and in that case I wanted to...
  12. xweyer

    Word "Send To" Question

    I have a simple Word form that I want make as easy as possible for a user to send. If I use File>Send To>Mail Recipient (as Attachment) I can get the form attached to an unaddressed email which is fine as far as it goes but since the addresses are always the same I'd like to find a way to have...
  13. xweyer

    Passing The Current Form Name For Use In Public Function

    I have a local procedure that checks that all the "required" fields have not been left empty (via the control's tag property) prior to saving the record. Since I have to do this for multiple forms I'd like to make this into a global function but can't figure how to pass the name of the current...
  14. xweyer

    Textbox AfterUpdate Issue

    I have a form with a text box aka txtOrgCode with code in the AfterUpdate event that check the user's entry against a set of rules. That code works as intended. As an alternative to directly entering data in txtOrgCode I also have another pair of text boxes which allow the user to enter a...
  15. xweyer

    Syntax for Like Operator with Function as Query Criteria

    I have a function "fProgram" attached to a global string variable (gblProgram) that I'm using as criteria in a query field ([Program]). This works fine when the variable is an exact match but what I'd like to be able to do is also show all records. If I try setting gblProgram as Null via VBA...
  16. xweyer

    Beginner's Question Re Stored Procedure Parameter

    I'm trying to understand the following code. "CREATE Procedure Adjustment @wSNN varchar(9)='%'" My question is what is the purpose of ='%'? I know that a parameter named wSNN of variable type varchar(9) is created but from reviewing command syntax I'm left with the perception that ='%'...
  17. xweyer

    Newbie Question re: Where Clause

    What is the difference between the following two statements "where t1.site_id = t2.site_id" and "where t1.site_id* = t2.site_id" In other words what does the asterisk signify?
  18. xweyer

    Select Into Question

    New to TSQL and trying to decipher the following line of code. Select Last_Name, First_Name,...etc..., t1.Region, NotCurrentOp into #TEMP. Since NotCurrentOp is not the name of any field from any table in the from statement I'm concluding that NotCurrentOp refers to a computed column that will...
  19. xweyer

    Select Syntax Question

    I'm new to TSql and am trying to interpret a line of code which reads.... SELECT 'ASSET' Category,id, program, "id" and "program" are fields from the source table but "Category" is not. So what is it? An alias of some sort?
  20. xweyer

    Newbie Questions re: Select Statement

    I'm new to TSQL and am trying to interpret a segment of code originating in a view I'm examining. The code reads as follows,"SELECT adj_id id, T2.ssn ,NULL Ceris" Here's my questions. 1.) Am I correct in assuming that adj_id is an alias for the "id" field (since none of the tables involved...

Part and Inventory Search

Back
Top