Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.05 seconds.
Search: Posts Made By: moke123
Forum: Forms 02-15-2019, 06:58 AM
Replies: 6
Views: 145
Posted By moke123
Re: Help Needed: Linking form and tab control details

in your log in form you have
DoCmd.OpenForm "frm_Instructor-InspectorDB"
Forms![frm_Instructor-InspectorDB]![TxtUser] = TempLoginID
...
Forum: Reports 02-12-2019, 09:32 AM
Replies: 6
Views: 109
Posted By moke123
Re: Eliminate Address Lines

you can also use the Law of Propigating Nulls. anything plus a null is null.

(Name + vbnewline) & (address1 + vbnewline) & (address2 + vbnewline) & etc.
Forum: Tables 01-30-2019, 03:44 AM
Replies: 3
[SOLVED] Loop issue
Views: 67
Posted By moke123
Re: Loop issue

" VALUES ('" & Me.txtPN & "' , '" & Me.txtSN & " ', ' " & Me.txtJN & "', '1' , i )" this may be resolving to a literal i instead of the value of i. The i is within the quotes.
try
" VALUES ('" &...
Forum: Modules & VBA 01-28-2019, 05:53 PM
Replies: 5
Views: 5
Posted By moke123
Re: Import from a folder with file names

Are you able to import the text and all you need is to get the file name?
Post the code you are using as I'm sure you can get the filename somewhere in it.
Forum: The Watercooler 01-15-2019, 04:36 PM
Replies: 25
Views: 817
Posted By moke123
Re: Adventures in Cable Cutting

Not sure which company I hate more, Cable Co. or Cellphone Co.

When Comcast bought Time Warner they decided that the were going to upgrade our service by going 100% encrypted digital. The result...
Forum: Tables 01-10-2019, 03:53 AM
Replies: 2
Views: 338
Posted By moke123
Re: How to add a record to a table with a link to another table?

try a budget subform with master\child link on jobid
Forum: Forms 12-31-2018, 09:36 PM
Replies: 9
Views: 317
Posted By moke123
Re: Changing Form Control Captions

Forms(oForm.Name)(oCtrl.Name).Caption = "newcaption"
This is new syntax for me. Just looks like there should be a dot between the variables. I use the syntax Colin posted as well as...
Forum: Modules & VBA 12-29-2018, 06:17 PM
Replies: 18
Views: 548
Posted By moke123
Re: VBA to handle duplicate selections in Subform.

heres your original db with the code from post#13
Forum: Modules & VBA 12-29-2018, 03:37 AM
Replies: 18
Views: 548
Posted By moke123
Re: VBA to handle duplicate selections in Subform.

try something like this in the combo box before update

Private Sub WeldProcedure2_BeforeUpdate(Cancel As Integer)

If DCount("*", "tblElectrodeWeldProc", "Electrode2 = '" & Me.Electrode2 &...
Forum: Modules & VBA 12-24-2018, 07:15 AM
Replies: 26
Views: 603
Posted By moke123
Re: How to prevent Duplicates when Null is involved

Bear in mind that Arnels solution, as written, will not work with names like O'Neal or O'Rourke. You would need to double up on the quotation marks.

you could also use the law of propagating...
Forum: Modules & VBA 12-24-2018, 06:19 AM
Replies: 26
Views: 603
Posted By moke123
Re: How to prevent Duplicates when Null is involved

you may also want to reconsider your event. What happens if they enter the last name first? the before update event will fire with no first or middle name.
Forum: Modules & VBA 12-24-2018, 05:03 AM
Replies: 26
Views: 603
Posted By moke123
Re: How to prevent Duplicates when Null is involved

Preventing duplicate names can be a difficult task when you consider that many people can have the same first and last names. 2 of the 3 people in my office with the same last name have the same...
Forum: Forms 12-19-2018, 02:26 PM
Replies: 9
Views: 249
Posted By moke123
Re: Custom inputbox/search form

Colin, what event is form_Loaf? :D
Forum: Forms 12-12-2018, 04:12 AM
Replies: 5
Views: 194
Posted By moke123
Re: How to avoid duplication

have you tried
me.YourButtonName.Enabled = false
you could also hide the button by moving focus somewhere else and setting the visible to false.
Forum: Queries 12-06-2018, 11:03 AM
Replies: 60
Views: 6,041
Posted By moke123
Re: Multi-Select Listbox as filter for Query field

Here's a quick example of building a where clause with a multi-select listbox.
If nothing is selected it returns all records.
Forum: Queries 12-06-2018, 03:46 AM
Replies: 60
Views: 6,041
Posted By moke123
Re: Multi-Select Listbox as filter for Query field

Put a "Select All" button next to the list box and run this code from it.
This code goes in a standard module.

Public Function SelectAll(lst As ListBox) As Boolean

On Error GoTo...
Forum: Forms 11-28-2018, 03:04 PM
Replies: 14
Views: 404
Posted By moke123
Re: Combo Box Filter and Label

CboIsComplete.DefaultValue = 0
is CboIsComplete a bound combobox?
if not I'm not sure you want defaultvalue.
you may want CboIsComplete = 0 although the 0 kinda confuses me.
what are the fields...
Forum: Forms 11-28-2018, 02:38 PM
Replies: 10
Views: 422
Posted By moke123
Re: Unbound Combo Box issue

We cant see the full criteria in the screenshots.
Is there a field Job in the underlying form recordsource?
Are you trying to reference the cmbJob (not Job) in the criteria?
Forum: Forms 11-18-2018, 05:40 AM
Replies: 9
Views: 255
Posted By moke123
Re: Hiding Combo Box Item

Again I agree that's possible or its just the way he's storing three values (which could also be an issue)

we actually didnt answer his question

which the answer would be yes, with a...
Forum: Forms 11-18-2018, 04:30 AM
Replies: 9
Views: 255
Posted By moke123
Re: Hiding Combo Box Item

good point Gasman, and correct, although I don't see where any order was requested just best 3.
Forum: Forms 11-17-2018, 02:40 PM
Replies: 9
Views: 255
Posted By moke123
Re: Hiding Combo Box Item

I agree with Colin on the Multi-select list box which was my first thought also. I just happened to try the combos first and it worked well.

If you want to try the list boxes take a look at the...
Forum: Forms 11-17-2018, 04:30 AM
Replies: 9
Views: 255
Posted By moke123
Re: Hiding Combo Box Item

is this what you mean?
Forum: Modules & VBA 11-16-2018, 06:04 AM
Replies: 12
Views: 261
Posted By moke123
Re: Refresh listbox in database 1 on the close event of database 2

I'm still trying to wrap my head around why you need to open DB2 and refresh the list in DB1. Is data being passed from DB2 to DB1 that affects the listbox?
Forum: Modules & VBA 11-14-2018, 11:46 AM
Replies: 15
Views: 358
Posted By moke123
Re: File copy problem

At the top of every module you should have

Option Compare Database
Option Explicit

option explicit forces you to declare your variables and will catch any errors.

see this article to get...
Forum: Modules & VBA 11-13-2018, 12:36 PM
Replies: 15
Views: 358
Posted By moke123
Re: File copy problem

louise,
You didnt answer the question about option explicit.

Dim Files
msCustomer = Me.fldCustomer
msJob = Me.fldJob
msMethod = Me.fldCastingMethod
msDate = Year(Date)
...
Showing results 1 to 25 of 500

 
Forum Jump



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