Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: sneuberg
Forum: Theory and practice of database design 05-22-2019, 03:52 PM
Replies: 12
Views: 4,446
Posted By sneuberg
Re: Database for Employee Training

From the SwitchBoard


Click on Train Matrix
Click on Create Required Training Matrix
Click to Enable Macros

You get prompted for a password.

Are you going to tell us how to get...
Forum: Theory and practice of database design 05-22-2019, 12:02 PM
Replies: 12
Views: 4,446
Posted By sneuberg
Re: Database for Employee Training

Sorry. I don't have the password.
Forum: Forms 03-30-2019, 08:42 AM
Replies: 14
Views: 2,252
Posted By sneuberg
Re: Requery a subform when another subform's control is updated

I believe the reason why no additional cloned forms show up in the navigation pane is because there are no additional forms in the situation you describe. I believe I've simulated the situation you...
Forum: Forms 01-25-2019, 06:28 AM
Replies: 4
Views: 49
Posted By sneuberg
Re: Passing the Variable via Forms

Why not just get the order number directly from the table? Maybe the DMax function (https://www.techonthenet.com/access/functions/domain/dmax.php) would work for you.
Forum: Modules & VBA 01-24-2019, 02:27 AM
Replies: 5
Views: 34
Posted By sneuberg
Re: Multi filter referencing field on form

You need to concatenate Me.UserName into the string otherwise it will be literally Me.UserName instead of its valued. Assuming User is a text field this would be something like:

strMyLast =...
Forum: General 01-23-2019, 09:51 AM
Replies: 19
Views: 1,021
Posted By sneuberg
Re: NZ Function Undefined (under certain conditions)

Maybe not so odd. On my Office 2013 system if I double click on an mdb file it uses an access 2010 runtime rather than my Access 2013. I think which version it uses on a double click depends on...
Forum: Modules & VBA 01-23-2019, 09:14 AM
Replies: 14
Views: 149
Posted By sneuberg
Re: Replace text in word from Access becomes bold when should not be bold

You can pass the Word.Document object to the subroutine like:

Sub msReplaceCellData(WordDoc As Word.Document, OrigText As String, ReplaceText As String, r As Integer, c As Integer)
With...
Forum: General 01-23-2019, 06:06 AM
Replies: 19
Views: 1,021
Posted By sneuberg
Re: NZ Function Undefined (under certain conditions)

I suggest checking your references. That's in Visual Basic, Tools, References. They may not be in sync with Office 2019.

I have to admire your courage. I'm still with Office 2013 with Windows...
Forum: Modules & VBA 01-23-2019, 05:57 AM
Replies: 10
Views: 94
Posted By sneuberg
Re: How to run vba for another databse

While this not a complete answer to your question you might be able to use the shell command to do this. This would open the new database. You would have to copy an autoexexec and a module to it...
Forum: Modules & VBA 01-22-2019, 09:59 AM
Replies: 14
Views: 149
Posted By sneuberg
Re: Replace text in word from Access becomes bold when should not be bold

I've attached a zip file with the Word Document and Access DB I used the to test this. Maybe seeing how I tested it will help you incorporate it into your code. The test code is in a the module...
Forum: Forms 01-22-2019, 09:04 AM
Replies: 2
Views: 24
Posted By sneuberg
Re: Outline of tabs disappearing

I think it has something to do with the theme. I noticed that if you go to the properties of the tab control (TabCtl7), Format tab and change Use Theme to No the appearance of the tabs go back to...
Forum: Modules & VBA 01-21-2019, 05:41 PM
Replies: 14
Views: 149
Posted By sneuberg
Re: Replace text in word from Access becomes bold when should not be bold

I think your answer lies in the way they are doing it in this thread https://stackoverflow.com/questions/18609963/to-find-and-replace-a-text-in-the-whole-document-in-ms-word-2010-including-tabl.
...
Forum: Forms 12-11-2018, 05:53 AM
Replies: 15
Views: 689
Posted By sneuberg
Re: Intermitttent - "You can't assign a value..", with a bound checkbox

I'd bet the DISTINCT part of the record source query is your problem. Access typically doesn't like to update records that are part of an aggregate although I don't know why it would complain about...
Forum: Forms 12-10-2018, 05:26 PM
Replies: 15
Views: 689
Posted By sneuberg
Re: Intermitttent - "You can't assign a value..", with a bound checkbox

Could this have anything to do with which record is the current record? If you scroll through the records does this occur on certain records?

Also I think I'd try to isolate whether this is a...
Forum: Tables 12-23-2017, 06:10 PM
Replies: 6
Views: 790
Posted By sneuberg
Re: Only allow duplicates of certain responses but not others

I believe this would be very difficult to implement at the table level. Access has data macros (kind of like table triggers) but I find them hard to work with. At the form level you could use the...
Forum: Forms 12-17-2017, 09:18 AM
Replies: 14
Views: 739
Posted By sneuberg
Re: One field determining the value of another field

I suggest downloading the Microsoft VBA Language Specification which you can get here (https://msdn.microsoft.com/en-us/library/dd361851.aspx)
Forum: Forms 12-13-2017, 05:28 PM
Replies: 14
Views: 739
Posted By sneuberg
Re: One field determining the value of another field

You could assign these values in the afterupdate event of the option group. Just test the value of the Dues and set the Memtype accordingly.
Forum: Forms 10-25-2017, 07:39 AM
Replies: 7
Views: 1,064
Posted By sneuberg
Re: Cancel data entry of a record

Maybe a button with

Me.Undo

might do want you want,
Forum: Queries 10-25-2017, 07:24 AM
Replies: 6
Views: 253
Posted By sneuberg
Re: Nested query not working

I think you need a comma after tblO.DateList and I don't think you can return two results in the same subquery. I suggest looking through the examples on this site...
Forum: General 10-15-2017, 07:30 PM
Replies: 7
Views: 1,560
Posted By sneuberg
Re: Transfer spreadsheet (to Excel) stopped working

Just a shot in the dark but maybe the Excel versions being expected changed. You might poke that argument with a stick.
Forum: Queries 09-29-2017, 06:57 PM
Replies: 6
Views: 1,484
Posted By sneuberg
Re: Delete query on a union

Let's say for example that the primary key of Shares is ShareId then I'd try something like.

DELETE *
FROM Shares
WHERE ShareId IN
(SELECT ShareId from Shares
Left JOIN (
SELECT...
Forum: Modules & VBA 09-28-2017, 06:39 AM
Replies: 10
Views: 630
Posted By sneuberg
Re: Couple of quick and probably stupid Access Form related VBA queries

I've created and attached a database with two forms, Form1 and Form2 with open and close buttons. All of these work on my system (Access 2013) and should work on yours. Please download this and...
Forum: Modules & VBA 09-26-2017, 05:39 AM
Replies: 10
Views: 630
Posted By sneuberg
Re: Couple of quick and probably stupid Access Form related VBA queries

If the name isn't specified I believe it closes the active form. Your syntax is correct the only reason I can see why that wouldn't work is frmProgressWindow being misspelled or not being open.

...
Forum: Modules & VBA 09-25-2017, 06:01 PM
Replies: 10
Views: 630
Posted By sneuberg
Re: Couple of quick and probably stupid Access Form related VBA queries

If you mean by "doesn't work" that the data in the form gets saved anyway then that's because the acSaveNo affects whether or not the form itself is saved, e.g, any change in the size of control if...
Forum: Forms 09-21-2017, 05:12 AM
Replies: 4
Views: 395
Posted By sneuberg
Re: Can I select a record based off a comboBox

If [Kit TOTE Number] is a numeric then try

rs.FindFirst "[Kit TOTE Number] = " & Nz(Me![totenumber], 0)

if it's text the combo box value needs to be in quotes so try

rs.FindFirst "[Kit TOTE...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 01:18 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