Home Forum Contact

 Access World Forums Search Results
 Register FAQ Members List Social Groups Top Posters Search Today's Posts

 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 User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World     Access World News     Site Suggestions     Introduce Yourself     The Watercooler Microsoft Access Discussion     General     Tables     Queries     Forms     Reports     Macros     Modules & VBA     Theory and practice of database design     Access Web Microsoft Access Reference     Access FAQs     Code Repository     Sample Databases     Microsoft Access Tutorials     Microsoft Access User Groups Apps and Windows     SQL Server     Crystal Reports     Visual Basic     VB.NET     Word     Excel     Web Design and Development         ASP and ASP.NET         PHP & MySQL     Windows     Other Software     Hardware Questions and Answers Non-Access Issues     Politics & Current Events     Debates     Gaming     Sports, Health & Fitness     Gadgets     Small Business

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