Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
cheekybuddha's latest activity
cheekybuddha
replied to the thread
Solved
Exporting a form as text and then importing.?
.
Did you delete the existing form before importing from text?
Apr 12, 2024
cheekybuddha
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
Probably more like: DoCmd.OpenForm "frmCustomerInvoice", Where:="1 = 0"
Apr 12, 2024
cheekybuddha
replied to the thread
Solved
the expression you entered is too complex
.
Change the form's RecordSource to: SELECT m.*, c.riskSLcode FROM TMain m INNER JOIN FriskSL c ON m.RiskCode = c.riskSLid Then...
Apr 12, 2024
cheekybuddha
replied to the thread
Solved
Move/Tab to next control
.
It might also be wise to use a different object variable for looping the .Controls collection in case ctrl is used subsequently in the...
Apr 11, 2024
cheekybuddha
replied to the thread
Solved
the expression you entered is too complex
.
Choose() is probably a better choice than Switch() if you want to avoid the table option.
Apr 11, 2024
cheekybuddha
replied to the thread
Solved
the expression you entered is too complex
.
There are 25 risk codes - with either Switch() or nested IIf(), my guess is that you are butting up against or beyond the maximum number...
Apr 11, 2024
cheekybuddha
replied to the thread
Solved
the expression you entered is too complex
.
When you have this many it's easier to create a table for risk codes; then join the table without the need for such an unwieldy...
Apr 11, 2024
cheekybuddha
replied to the thread
Opentextfile leads to error 5
.
Do this. (y) Option Explicit will then be added automatically to all new code modules But you will also need to add it manually to...
Apr 10, 2024
cheekybuddha
reacted to
arnelgp's post
in the thread
Opentextfile leads to error 5
with
Like
.
or you can set it once in VBA (tools->options)
Apr 10, 2024
cheekybuddha
replied to the thread
Opentextfile leads to error 5
.
Make sure you have Option Explicit declared at the top of every code module (above or below Option Compare Database). This will catch...
Apr 10, 2024
cheekybuddha
replied to the thread
Pass through queries with parameters in access
.
Yes. How are you executing your pass-through?
Apr 9, 2024
cheekybuddha
replied to the thread
Show Data for this week only
.
If you change to SQL view you can make the WHERE clause look like: ... WHERE AnticipatedCompletionDate >= DateSerial(Year(Date())...
Apr 8, 2024
cheekybuddha
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
ADODB.Recordset.GetString method
Apr 7, 2024
cheekybuddha
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
No it doesn't - it's one SELECT call for every thousand records. If there are fewer than a thousand records, then it's just one query...
Apr 7, 2024
cheekybuddha
replied to the thread
Insert Data from an Access table to a similar table in MS SQL Server
.
It is an action query, just performed on the server (which would probably be even faster than from Access) of up to 1000 records at a...
Apr 7, 2024
Home
Members
Top
Bottom