Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 414
Search took 0.06 seconds.
Search: Posts Made By: MajP
Forum: General Today, 06:52 AM
Replies: 4
Views: 43
Posted By MajP
Re: Bit of a weird one

You may still want to be safe and create the clean db.
Forum: Excel Today, 06:51 AM
Replies: 6
Views: 45
Posted By MajP
Re: Formula to Convert Number with Decimals to feet and inches including fractions

No it works fine in excel
=DecInchesToString(someCellReference)
Forum: Excel Today, 06:14 AM
Replies: 6
Views: 45
Posted By MajP
Re: Formula to Convert Number with Decimals to feet and inches including fractions

Its a function. Do not have to understand it, you can simply use it. Just drop it in a standard module. Then simply

= DecInchesToString(CELLREF)
Forum: Excel Today, 05:08 AM
Replies: 6
Views: 45
Posted By MajP
Re: Formula to Convert Number with Decimals to feet and inches including fractions

If you did not run it here is the output of my test
6 Feet 0 Inches
6 Feet
6 Feet 11 Inches
6 Feet 11 Inches
6 Feet 11-11/32 Inches
6 Feet 11-11/32 Inches
0 Feet 11-11/32 Inches
11-11/32...
Forum: Excel Today, 04:59 AM
Replies: 6
Views: 45
Posted By MajP
Re: Formula to Convert Number with Decimals to feet and inches including fractions

Just did this in another thread

Public Function DecInchesToString(ByVal DecimalInches As Double, Optional ShowZeros As Boolean = True) As String
Dim Feet As Long
Dim Inches As Long
Dim...
Forum: General Today, 03:48 AM
Replies: 4
Views: 43
Posted By MajP
Re: Bit of a weird one

I have never seen anything like that. I would create a new database. Import the tables into it. Do a compact and repair. Then import all the other objects. Then compact and repair on more time and...
Forum: Modules & VBA Yesterday, 01:36 PM
Replies: 3
Views: 71
Posted By MajP
Re: Trouble with Random number exclusions

The other simple way would be to make a table with picture names in it. In your case the names are 1 to 50. Then make a query with a random number column and sort by that column. Open in order. ...
Forum: Queries Yesterday, 01:26 PM
Replies: 16
Views: 213
Posted By MajP
Re: Match Word in Sentence

Unless I am misunderstanding, isn't that exactly what my query does? According to your post I do not have to check the length of field 58, 57, 56, 54 since they always eleven characters. I just need...
Forum: Queries Yesterday, 10:14 AM
Replies: 16
Views: 213
Posted By MajP
Re: Match Word in Sentence

With that said I think you would modify the query
SELECT TEST.*, EXTRACT.*, "Field58" as FieldName
FROM [EXTRACT], TEST
WHERE InStr([TEST].[DELETION],left([EXTRACT].[58],7))>0
UNION
SELECT...
Forum: Queries Yesterday, 08:48 AM
Replies: 16
Views: 213
Posted By MajP
Re: Match Word in Sentence

You show in the table
"There is a change to BBBBBBB and it effective 15 Dec"
And the value in the column is BBBBBBBBXXXX
Are you always looking for the first seven characters or any of the sub...
Forum: Forms 09-18-2018, 06:02 PM
Replies: 53
Views: 1,094
Posted By MajP
Re: OPening more than one occurrence of a form

.
I am not very smart, but I learned how to be smarter than most people who consider themselves to be "Access Developers". I learned how to use the Object Explorer in the VBE. Using that I can find...
Forum: Forms 09-18-2018, 05:54 PM
Replies: 53
Views: 1,094
Posted By MajP
Re: OPening more than one occurrence of a form

So the questions that you are now asking have nothing to do with form instances. You are opening a non dialog form and you want to set certain properties. I would probably say to open a new thread,...
Forum: Forms 09-18-2018, 07:54 AM
Replies: 53
Views: 1,094
Posted By MajP
Re: OPening more than one occurrence of a form

Yes my fault, I was just trying to list some properties. My example should be
.OrderBy = "SomFieldName"
.OrderByOn = True
Forum: Modules & VBA 09-18-2018, 07:40 AM
Replies: 15
Views: 181
Posted By MajP
Re: Add Multiple New Records to a Existing Table

If not clear that creates 15 records in Table2 and sets the Cost field to 0.
Forum: Modules & VBA 09-18-2018, 07:39 AM
Replies: 15
Views: 181
Posted By MajP
Re: Add Multiple New Records to a Existing Table

Again, like everyone else, let us help you come up with a better way. But if you insist here is a generic function to add x records and set one fields value.

Public Sub InsertRecords(TableName As...
Forum: Modules & VBA 09-18-2018, 07:28 AM
Replies: 6
Views: 132
Posted By MajP
Re: VBA to reuse data entry popup form

So the way this works it pops open any form in Dialog. At that point the code calling it Stops. When you hide the form on the OK button code resumes. The function then checks if the form is...
Forum: Modules & VBA 09-18-2018, 07:25 AM
Replies: 6
Views: 132
Posted By MajP
Re: VBA to reuse data entry popup form

Yes that is my code. I would never have a pop up form hard wired to set the value on another form. That is just bad design in my opinion. No flexibility. The calling form should be able to call a...
Forum: Modules & VBA 09-18-2018, 04:28 AM
Replies: 15
Views: 181
Posted By MajP
Re: Add Multiple New Records to a Existing Table

I find INSERTs confusing if there are a lot of columns (matching te column to the value can be tricky). Is there a good reason not to use a RecordSet?
Not really. An insert is more efficient, but...
Forum: Modules & VBA 09-17-2018, 04:26 PM
Replies: 15
Views: 221
Posted By MajP
Re: Access VBA not changing Word Font.Color

If variable declaration was not compulsory, it would compile.

Yeah, I forgot that is actually a thing. One of the most stupid things in VBA allowing you not to declare your variables. About as...
Forum: Modules & VBA 09-17-2018, 03:04 PM
Replies: 15
Views: 181
Posted By MajP
Re: Add Multiple New Records to a Existing Table

The code is basically
Dim I as integer
dim numRecords as integer
dim strSql as string
numRecords = me.somecontrolvalue
for I = 1 to numRecords
'insert query goes here
strSql = "INSERT into...
Forum: Modules & VBA 09-17-2018, 02:28 PM
Replies: 15
Views: 221
Posted By MajP
Re: Access VBA not changing Word Font.Color

One other thing. This looks like you are attempting late binding, but you are not since you obviously have a reference to Word. If that was not the case then
.Replacement.Font.Color = wdColorRed...
Forum: Modules & VBA 09-17-2018, 02:21 PM
Replies: 15
Views: 221
Posted By MajP
Re: Access VBA not changing Word Font.Color

Not sure if it is your problem, but I do not know why you would work with a Selection object. Seems like such a round about way. You should be working with a Range object instead.
Forum: Forms 09-17-2018, 10:23 AM
Replies: 53
Views: 1,094
Posted By MajP
Re: OPening more than one occurrence of a form

I cannot edit my posts due to some restrictions on my computer. For the query method should read ".recordsource" not ".rowsource".
Forum: Forms 09-17-2018, 10:21 AM
Replies: 53
Views: 1,094
Posted By MajP
Re: OPening more than one occurrence of a form

There are 3 ways I can think of to limit the records. Use a filter, change the recordsource query, or you could even set the recordset.


dim rs as dao.recordset
set rs = currentdb.openrecordset...
Forum: Forms 09-17-2018, 09:53 AM
Replies: 53
Views: 1,094
Posted By MajP
Re: OPening more than one occurrence of a form

"Pass In" was a bad term. Should have said you can set the properties once you create the instance, because creating the instance also opens the form.
Showing results 1 to 25 of 414

 
Forum Jump



All times are GMT -8. The time now is 07:24 AM.


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

Sponsored Links

How to advertise

Media Kit


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