Search results

Hi all, I am not that good with VBA but I am trying. I want to make a backup copy of a table every month using a macro that inserts the current date and time into the name of the table. I tried using copy object as shown below but it just pastes the name as written? Function Macro1() On Error...

Hello, I am pivoting my query and then using a percent as total column. When I export to excel it only displays the underlying values and not the percents? Does anyong know how to keep the formulas when exporting to excel. thanks!

warning I just make sure I set warnings "on" now consistently after I turn them off in my macros. My issue is resolved.

thanks I used: DATETIME_GENERATED: Year(Now()) & "-" & Month(Now()) & "-" & Day(Now()) & " " & Hour(Now()) & ":" & Minute(Now()) & ":" & Second(Now())

I have a query where I extract today's date and time using now() but need the extracted file to display the date/time as YYYY-MM-DD HH:MM:SS any help is greatly appreciated

I am new to crystal and I am trying to summarize data to one line. I have it summarized to one line but encountered one issue. I have a flag field where I want to summarize to a value I specify. Example: in my details I have 2 records for a member with flags P or S. In the group header I want...

reply yes on all questions, tables are linked by a key the main table has a autonumber field thanks

reply sorry cannot send I know how to create an append query but only want to copy/paste for the current record chosen by the user while viewing a single form. thanks

reply How to I duplicate though just the current record that the user is viewing? Right now I can duplicate the main form record and the id is assigned for the main form and subform. I just will not copy the subform to subform. I am not sure how to modify the VB to copy the subform elements...

reply The main form and subform is linked. When I add a new record it works fine. I want to be able to copy the current record to a new one and at the same time assign the new key. It works for the main form but not the sub-form.

I have a form and a subform. The DB was pre-existing so I am trying to work with it. I used the wizard to create a duplicate record button to cut down on entry data for the user. When viewing a certain record I want to be able to copy and paste the data in the form and subform into a new record...

The add new record works BUT I created a copy record from the wizard but it only copies the main form to a new record. I want to copy and paste the data in the main form and the subform and still create the new id in the mian form and copy this id to the subform. any ideas?

I have one form and a table with an autonumber id field. I have a second table with an ID field as a subform. I set-up the master and child links. When I add a new record to the main form the new id appears in the main and subform but the new id does not appear in the subform table??? I am...

I figured out the issue but how do I make the subform only appear via a click?

I have the form and subform instance. Master autonumber ID linked to ID on the child table. When I add a record the Master ID does not appear in the Child ID field? I am baffled.. help

reply thanks That's is what I figured but I was hoping the subform could be another screen? Can this be done and still have the copy command and add command work? thanks Bob

I have a form wdriven by an underlying query with 3 tables linked. 2 of the tables are linked by id and one by zip code. The master table has an auto id and the child table has an id field. I used the wizard to create an add record button and copy record button. When I use any of these buttons...

I have installed audit trail but when I edit an existing data field and then try to move to the next record I get a 3251 error - Operation is not supproted for this type of object help!

fixed it - thanks what does ME. mean?

reply thanks I am getting object required error?