Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.64 seconds.
Search: Posts Made By: pbaldy
Forum: Modules & VBA Today, 09:33 AM
Replies: 20
Views: 144
Posted By pbaldy
Re: Module - Audit Trail: Read Only Error

I don't use ADO much so I'll let theDBguy follow up on his thoughts. Presuming the table is linked, can you add a record directly in the linked table?
Forum: Modules & VBA Today, 09:13 AM
Replies: 20
Views: 144
Posted By pbaldy
Re: Module - Audit Trail: Read Only Error

My post was not aimed at solving the current problem, just preventing a future one. Temporarily comment out

On Error GoTo AuditChanges_Err

run the code so you can hit debug and see what line...
Forum: Modules & VBA Today, 09:01 AM
Replies: 20
Views: 144
Posted By pbaldy
Re: Module - Audit Trail: Read Only Error

No, the forms and code should be in the front end.
Forum: Modules & VBA Today, 08:58 AM
Replies: 20
Views: 144
Posted By pbaldy
Re: Module - Audit Trail: Read Only Error

FYI, this line:

rst.Open "SELECT * FROM tblAuditTrail", cnn, adOpenDynamic, adLockOptimistic

is opening the entire table every time, which could turn into a performance problem at some point. ...
Forum: Reports Today, 07:00 AM
Replies: 11
Views: 105
Posted By pbaldy
Re: background color value

Which control? You can make a textbox look the same as a label.
Forum: Reports Today, 06:55 AM
Replies: 11
Views: 105
Posted By pbaldy
Re: background color value

Have you looked at Conditional Formatting, on the ribbon?

FYI I'm going to move this thread to a more appropriate forum. Welcome to AWF!
Forum: Forms Today, 06:41 AM
Replies: 11
Views: 68
Posted By pbaldy
Re: autofill values for logged in users

That is VBA code:

http://www.baldyweb.com/FirstVBA.htm
Forum: Forms Today, 06:21 AM
Replies: 11
Views: 68
Posted By pbaldy
Re: autofill values for logged in users

I just tested this and it worked fine. I used the name of a textbox bound to a field in the table:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Text16 = Environ("username")
End Sub
Forum: Forms Today, 05:03 AM
Replies: 11
Views: 68
Posted By pbaldy
Re: autofill values for logged in users

Logged into Windows? Try Environ("username").
Forum: Forms Today, 05:02 AM
Replies: 12
Views: 1,346
Posted By pbaldy
Re: Using DSum in a text box

You realize that will sum the entire table without a criteria?
Forum: Forms Yesterday, 09:21 AM
Replies: 15
Views: 135
Posted By pbaldy
Re: Show Button Only for Admins

Well, it doesn't need to be a function, it could be a variable previously set with the user's access level. Also, you don't need a user to log in, you could use the Windows login if appropriate.
Forum: Forms Yesterday, 07:54 AM
Replies: 15
Views: 135
Posted By pbaldy
Re: Show Button Only for Admins

I haven't viewed it but Steve's stuff is usually pretty good:

https://www.youtube.com/watch?v=DxRpo496w_c&t=538s
Forum: Forms Yesterday, 06:34 AM
Replies: 15
Views: 135
Posted By pbaldy
Re: Show Button Only for Admins

You can't use a table field that way, unless it's part of the record source of the form this code is in. Many implementations of user security use a recordset or DLookup() to pull the access level...
Forum: Forms Yesterday, 06:26 AM
Replies: 15
Views: 135
Posted By pbaldy
Re: Show Button Only for Admins

That code looks okay. What exactly is UserAccess and how is it populated?
Forum: Forms Yesterday, 06:17 AM
Replies: 15
Views: 135
Posted By pbaldy
Re: Show Button Only for Admins

Why don't you post the code you're trying to implement and we'll fix it?
Forum: Forms 07-17-2019, 08:23 AM
Replies: 3
Views: 83
Posted By pbaldy
Re: Event procedure to change record

Thanks for updating the thread with your solution. Is it always on or off, never both? If so, why two fields instead of one?
Forum: Modules & VBA 07-16-2019, 08:32 PM
Replies: 6
Views: 105
Posted By pbaldy
Re: Exporting to SQL Server

I did say simplest.
Forum: Modules & VBA 07-16-2019, 05:53 PM
Replies: 6
Views: 105
Posted By pbaldy
Re: Exporting to SQL Server

Simplest would be if you can link to the SQL Server table(s) in Access. Then it's a simple append query.
Forum: Modules & VBA 07-16-2019, 04:41 AM
Replies: 1
Views: 77
Posted By pbaldy
Re: Use variable in select SQL field

Should work. Use this to see how the SQL is coming out:

http://www.baldyweb.com/ImmediateWindow.htm

You may need to add brackets if the field name has spaces or symbols.
Forum: Forms 07-15-2019, 06:49 AM
Replies: 4
Views: 150
Posted By pbaldy
Re: Maintain cost after order submitted and price changes??

Well, in my view the easiest way to do that is to save the selling price in the order details table along with quantity. It would be simple to populate that field when the user selects a product...
Forum: Forms 07-15-2019, 04:54 AM
Replies: 5
Views: 136
Posted By pbaldy
Re: How to make a text box to perform as a combo/list box

I would use the after update event; the change event fires with every keystroke.
Forum: Forms 07-14-2019, 08:59 AM
Replies: 3
Views: 95
Posted By pbaldy
Re: Disappearing textbox on subform

Also note the controls on a form or subform will disappear if the form returns no records and doesn't allow new records.
Forum: Forms 07-12-2019, 05:25 PM
Replies: 4
Views: 150
Posted By pbaldy
Re: Maintain cost after order submitted and price changes??

Typically you'd save the selling price as a field in the table recording sales details.
Forum: Forms 07-12-2019, 04:49 AM
Replies: 5
Views: 136
Posted By pbaldy
Re: How to make a text box to perform as a combo/list box

http://allenbrowne.com/casu-14.html
Forum: Introduce Yourself 07-12-2019, 04:43 AM
Replies: 4
Views: 82
Posted By pbaldy
Re: New to the Form

Welcome aboard Kevin!
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:59 PM.


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