Search results

isladog, have you seen the code that I am using to clear the clipboard? It is what I copied from your example. Am I applying it wrong or what?

I don't know what this method is called, but it is how I'm bring forward what I want from the previous form to the new form(s) us a control labeled "Cont" to call a sub-routine with this code in the body of it: DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy...

I call this from a sub using this: ClearClipboard. The module's name is: MyClearClipboard. This is it: UG Added Code Tags Option Compare Database Option Explicit '##################################### 'API declarations #If VBA7 Then 'A2010 and later (32/64-bit) Public Declare PtrSafe...

I used your sample that you referred to in my module, with a name as you suggested. I know that the call from my sub 'runs' the module, because I can halt it using breakpoint setting. Whether it clears the clipboad, is unknown, because one of those nasty 'paste error' messages appeared while...

Isladogs, my version of A2007 doesn't contain the "Microsoft Forms 2.0 Object Library". Is what it does contain in another library or what? Using you your code (above), when I insert 'ClearClipboard' in a control's VBA and run that code, I get a message saying "Expected variable or procedure...

To all of you who responded to my post - firstly, thanks. Secondly, the reason for my asking for 'VBA' way to empty the clip board is that I want to do that, a when I open a form that will bring forward data from the previous form to reduce the entering of data that doesn't change from...

I tried several suggestions that I was able to find on the 'net, but none of them cleared the clipboard. I am aware of the manual method, but would like to know if anyone has be successful using VBA, like using a module that can be called when forms load, for example. Thanks in advance.

You are absolutely correct. I realized that the current code does what I needed done, then. I was hoping (lazy) that a tweak here and there would relieve me of having to exercise the gray matter some more. I guess at 84+ that it won't hurt to keep it spinning. I'll do what you recommended...

Tried amending what you recommend, several different times and ways. I'm thinking that my problem with all of the columns/rows being transferred has something to do with the statement containing 'EOF', but am too ignorant to know what to do instead. Also, don't know about the # tag. I'll...

I could do that. It would be a bit unsophisticated, because I have 21 queries to deal with. In the past, I just used the code that I submitted to create two separate spread sheets: one for the previous year, one for the current year and deleted the columns that I didn't need for the auditor...

Yes, Paul. The submitted code exports all of the records for the full year to the spreadsheet. I tried to set the values of the constants (eg, <14 to <7) to display 6 columns, but all columns still display. I, also, tried rearranging the do-loops without success. The code that I'm using was...

This code works fine to file a year's profit & loss spreadsheet. Tried to get it to work correctly to use the same queries, but only to fill months Jun thru Dec for 2018, in columns B-G. Then, for 2019, I'll use the same code in 2019's db to add months Jan thru Jun in columns H-M to complete...

Re: Reports displaying multiple records Ok arnelgp, You did it. You, graciously, tolerated my ignorance and performed the magic that I desperately needed: the solution to my last problem with the never-ending-database project. Now, I can sleep soundly. As time went on, without my being able...

Re: Reports displaying multiple records I see the modification to the code. Neat. Another learning opportunity. I guess it's a never ending journey, this Access stuff. One final nit picking problem: only the first fueling record appears, even though the tables contain more than one (like...

Re: Reports displaying multiple records Arnelgp, my apologies for not recognizing what you did, until this morning. I didn't test all of the controls on the 'Select' form, only the middle one. What you achieved eliminated the need for the opening the individual 'trip' & 'fuel' reports. Thank...

Re: Reports displaying multiple records I know that that some of the records are incomplete,They contain enough information to exist as records with a T_TN or F_SerNo, which is sufficient to demonstrate my problem. Thanks for replying.

Re: Reports displaying multiple records Thanks for the opportunity to send my db. Have a good laugh at my code. It's alright. After "we' solve the multiple display problem on the reports, the next and final hurdle is to combine the trip sheet & fueling report on a single page. This post was...

I tried changing the T_Tn to an integer and a string & converted statement to open the report to match both recommendations, but the report still didn't show only 1 group. It's the end of my day, here, and my brain is saturated. I'll try again, tomorrow. I thank you, both, and learned some...

I submitted this earlier, but didn't receive any response(s). My Access 2007 table holds 25 groups of trip records. The individual group records are sequentially numbered trip leg record sets, such as: 1.01, 1.02. . .etc. for the for as many legs for the first group, 2.01, 202...etc. for the...

My Access 2007 table holds 25 groups of trip records. The individual group records are sequentially numbered trip leg record sets, such as: 1.01, 1.02. . .etc. for the for as many legs for the first group, 2.01, 202...etc. for the second group and so on for all 25 groups. Objective: Select any...