Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.80 seconds.
Search: Posts Made By: pbaldy
Forum: General Yesterday, 03:05 PM
Replies: 7
Views: 1,270
Posted By pbaldy
Re: Application slow over VPN

2.5 year old thread?
Forum: Forms 10-14-2019, 06:54 PM
Replies: 32
Views: 302
Posted By pbaldy
Re: Updating a record through adodb (without ODBC) -getting error

I've always used a file DSN or DSN-less code. Would user or machine DSN's be handled with a reg file directly or manually via the UI?
Forum: Modules & VBA 10-14-2019, 01:02 PM
Replies: 9
Views: 130
Posted By pbaldy
Re: Iterate thorough listbox field with values using DAO

Yes, you'll have a problem. That's one of many reasons most of us avoid MVF.
Forum: Forms 10-14-2019, 12:59 PM
Replies: 32
Views: 302
Posted By pbaldy
Re: Updating a record through adodb (without ODBC) -getting error

I'm glad you have a solution but could you expand on this .reg file that you have to maintain on each user's computer? Apparently I'm not the only one that's never had to bother with it. I've got...
Forum: Forms 10-14-2019, 10:05 AM
Replies: 32
Views: 302
Posted By pbaldy
Re: Updating a record through adodb (without ODBC) -getting error

In 20+ years I don't think I've ever dealt with (or even heard of) a .reg file required by linked tables, and I use tables linked to SQL Server the vast majority of the time.
Forum: Forms 10-14-2019, 08:10 AM
Replies: 32
Views: 302
Posted By pbaldy
Re: Updating a record through adodb (without ODBC) -getting error

If you want the form to be editable, this type of thing should work. Even if you don't, it's a lot simpler.

Dim strSQL As String
Dim db As DAO.Database
Dim rs As DAO.Recordset...
Forum: Introduce Yourself 10-14-2019, 07:11 AM
Replies: 8
Views: 437
Posted By pbaldy
Re: Introduction

Wow, a 5+ year old thread?
Forum: Queries 10-12-2019, 11:06 AM
Replies: 10
Views: 114
Posted By pbaldy
Re: split field

I'll get out of the way.
Forum: Queries 10-12-2019, 11:05 AM
Replies: 10
Views: 114
Posted By pbaldy
Re: split field

So 1 character per field? You're probably going to have to loop the characters, but I don't feel I have enough info to get more specific.
Forum: Queries 10-12-2019, 10:51 AM
Replies: 10
Views: 114
Posted By pbaldy
Re: split field

Huh? What do you expect to be the results from each of those numbers?
Forum: Queries 10-12-2019, 10:44 AM
Replies: 10
Views: 114
Posted By pbaldy
Re: split field

What rules govern the split process? Options include Left(), Right(), Mid().
Forum: Modules & VBA 10-12-2019, 07:37 AM
Replies: 10
Views: 198
Posted By pbaldy
Re: Problem with Looping

Perhaps adding a where condition using the value from the recordset?

http://www.baldyweb.com/wherecondition.htm
Forum: General 10-11-2019, 10:02 AM
Replies: 7
Views: 134
Posted By pbaldy
Re: Maintaining database on remote

I suspect the two major methods are remoting into their computer as CJ mentions (Teamviewer, etc) or making the changes on your computer and sending the customer the new front end. You can replicate...
Forum: Forms 10-11-2019, 09:59 AM
Replies: 32
Views: 302
Posted By pbaldy
Re: Updating a record through adodb (without ODBC) -getting error

The error implies that isn't the name of the textbox, so I'd start with double checking that. I've had times where it was correct but I had to retype it.
Forum: Theory and practice of database design 10-10-2019, 08:58 AM
Replies: 8
Views: 157
Posted By pbaldy
Re: Ways to read a recordset

More on using recordcount:

http://baldyweb.com/RecordCounts.htm
Forum: Theory and practice of database design 10-10-2019, 07:53 AM
Replies: 8
Views: 157
Posted By pbaldy
Re: Ways to read a recordset

Oh, and I use the EOF test rather than recordcount.
Forum: Theory and practice of database design 10-10-2019, 07:52 AM
Replies: 8
Views: 157
Posted By pbaldy
Re: Ways to read a recordset

I would use the second method, as it only pulls the desired record(s) across the network. The first pulls all records, which would be a performance issue with larger tables.
Forum: Forms 10-09-2019, 04:01 PM
Replies: 13
[SOLVED] Date with null
Views: 130
Posted By pbaldy
Re: Date with null

Happy to help! There's a one-line solution along the lines of:

BUD = IIf(Nz(drug_name.Column(3), "") = "", 0, CInt(drug_name.Column(3)))
Forum: Forms 10-09-2019, 03:57 PM
Replies: 13
[SOLVED] Date with null
Views: 130
Posted By pbaldy
Re: Date with null

From the image it appears the combo has a zero length string rather than Null. Perhaps something like

If Len(drug_name.Column(3) & vbNullString) > 0 Then
BUD = CInt(drug_name.Column(3))
Else...
Forum: Forms 10-09-2019, 03:47 PM
Replies: 13
[SOLVED] Date with null
Views: 130
Posted By pbaldy
Re: Date with null

On what line? Can you attach the db here?
Forum: Forms 10-09-2019, 03:39 PM
Replies: 13
[SOLVED] Date with null
Views: 130
Posted By pbaldy
Re: Date with null

What is BUD? I assume a variable, but it isn't declared here. What exactly does that combo column contain? If it's text, you might need to convert it

BUD = CInt(Nz(Item_name.Column(3), 0))
...
Forum: Forms 10-09-2019, 03:35 PM
Replies: 13
[SOLVED] Date with null
Views: 130
Posted By pbaldy
Re: Date with null

Did you try the Nz() function I suggested?
Forum: Forms 10-09-2019, 03:27 PM
Replies: 13
[SOLVED] Date with null
Views: 130
Posted By pbaldy
Re: Date with null

Try

BUD = Nz(name.Column(3), 0)

Name is not a good field/control name as it is a reserved word. It can conflict with the Name property of an object.
Forum: General 10-07-2019, 06:29 PM
Replies: 19
Views: 215
Posted By pbaldy
Re: email field

Geez, I guess I was too slow. :rolleyes:
Forum: General 10-07-2019, 05:58 PM
Replies: 19
Views: 215
Posted By pbaldy
Re: email field

Use

Me.custemail

For that argument.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:48 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World