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...
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...
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...
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?
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) ='" &...
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...
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...
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...
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...
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?
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...
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...
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...
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...
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...
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 ='%'...
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?
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...
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.