CLSkcab
Last Activity: Dec 9 '14, 06:30 PM
Joined: Aug 26 '14
Location:
-
Totals on a Datasheet
How do you display totals on a datasheet view? For example, the total number of records (see attached).... -
Can one Access 2010 program call another Access 2010 program?
Background:
Front End: MS Access 2010/VBA, Back End: MS SQL Server 2008
Can an Access 2010 program start another Access 2010 program and pass data to the one it starts?
Thanks in advance. -
Got it to work. Had to remove the Link Master Fields and Link Child Fields values. -
Here is my code. I put in the "Look Up" button....Code:Private Sub cmdNext_Click() Dim sSearch As String sSearch = Nz(Me.fCompany.Value, "") If Len(sSearch) > 0 Then Me.[signin subform].Form.Filter = "Company LIKE '*" & sSearch & "*'" Me.[signin subform].Form.FilterOn = True Else Me.[signin subform].Form.FilterOn = FalseLeave a comment:
-
What is me.companysub.f orm referring to?Leave a comment:
-
Query Improvement
Background-
Front end: MS Access 2010/VBA
Back end: MS SQL Server 2008
Me: Scale 1 - 10 (10 being high) Access: 5 SQL: 4
I have a form/sub form combo that solicits the visitor for their company name (see attached).
After they press the "Look Up" button the query will list the company along with the company's
location. The Link Master Fields and Link Child Fields causes the query to work.... -
How to run reports automatically
Background-
Frontend: MS Access 2010 / VBA
Backend: MS SQL Server 2008
I have 3 MS Access reports that needs to been run weekly. The department responsible for the reports does this but want the reports to run automatically. Does anyone have any ideas?
Thanks in advance for your help. -
I have a SQL table record:
ID int primary key
IDUser int secondary key points to the parent
Program varchar(50)
Role varchar(5)
.
.
.
I know the secondary key and program values. Hoe can I get the Role value? Any help will be appreciated. I did find where you can't use a Select like this.Leave a comment:
-
I did as you requested and put in (,). This time I get the following message: Run-time error 3075, Syntax error (comma) in query expression 'Program='Secur ity', IDUser=1'Leave a comment:
-
SQL error
Background: Front End MS Access 2010 with VBA; Backend SQL Server 2008; Still learning SQL
I have the following statement codedIt is generating this error: Run-time error (missing operator) in query expression Program='Securi ty' IDUser=1'. What is wrong?Code:gblsSQL = "Select Role FROM [dbo_UserProgram] Where Program='Security' IDUser=" & gblID & ";"
Thanks in advanced. -
Invalid use of Null
Frontend: MS Access 2010/VBA
Backend: MS SQL Server 2008
This code is used to determine the the current key (ID) of a table entry. When the table is empty however the following message is issued: Run-time error '94' Invalid use of null. How do I get around this?
...Code:Private Sub getID() Dim OldCaseNum As Integer OldCaseNum = DMax("ID", "[dbo_BWC]") End Su -
It is too complex for me at this time and it is a low priority item. Thanks anyway.Leave a comment:
-
Attachments
Background: Frontend MS Access 2010/ VBA; Backend MS SQL Server 2008. Learning Access VBA and SQL
I have an Access application that needs to have the backend DB store an attachment. The Access code is written in VBA. How can this be accomplished? I would like to do it much like a native Access program. Please see attachment.
The best I could find was to create the field in SQL as a varbinary(MAX).
... -
It worked. Thank you.Leave a comment:
-
Displaying Error Message when no data found in a query
How do I display an error message when no data is found in a query. Attach is the query.
The user enters a company's name. If the name is not there I want to display a MsgBox s the knows either he/she misspelled it or it is not there.... -
Check Boxes
Background- Foreground MS Access 2010; Background MS SQL Server 2008; this program is written in Access/vba.
On a form I have a check box field. When the check box is checked (true) how do I turn on the visibility of certain fields below it? See attached.... -
Numeric versus Long Integer
Background
Frontend MS Access 2010 w/ VBA; Backend MS SQL Server 2008
Just learning SQL
My Problem
I have a SQL table with a field named QTY and it is defined as numeric(18,0). It is being read into a field that is defined as DIM gblQTY as Long.
...Code:gblQTY = Nz(DLookup("QTY", "dbo_part Shortages", "[key] = '" & gblKey & "'")) -
That did the trick. Thank you.Leave a comment:
-
Moving a numeric field to integer
Background: Front end MS Access 2010; back end MS SQL Server 2008; limited knowledge in SQL
I have a field named QTY in a SQL table defined as numeric (18,0) and has a value of 60000. The program is reading this field in a
variable defined as integer - Dim gblQTY as Integer. I am getting a run time error '6' - Overflow. What is wrong? Thanks in advanced. -
Right on. Thank you very much.Leave a comment:
No activity results to display
Leave a comment: