Search results

Hi I am trying to export a filtered search from a datasheet to an excel spreadsheet - only including certain columns. I am using the below code but it is falling over on the column selection. Without that part it exports fine but i really want to exclude some columns from the export. Private...

It is currently set as a macro, not a code. I don't know how to do it. I am new to code. I have been searching for a code to modify but its all new to me. :(

I mean, I have created the database for someone else, I will not be using the database so I have added an export button on the form which the user will click to export the selected records from the form. I dont know how to set the query up to export just the selected records that have been...

Dear Bob, I have a query which I have searched on and I can't find the right solution. I was looking at your codes (below and on your web page) but I dont understand how I can use or modify them to do this:- I have a form that I can filter records on, the form also contains calculations, I set...

Yes, but I will not be actioning the exports, this is a database I have set up for someone else. So I want to set up a command button that when clicked exports and opens in excel from the filtered selected on a form with those columns removed. It's a tricky one. They could always delete the...

The export to excel runs from the form, with the filtered records selected. This exports to excel - which works fine but as the calculatations are in the form, and I export from the form - the excel output includes the calculations. I dont know how to exclude those columns from apprearing. If...

Hi I have a form set to datasheet view. When records are filtered, I have a macro set up to export this selection to an excel spreadsheet. This works fine, however I have 2 calulated fields which appear in the export and I been asked if these can be hidden or deleted from the export? I have...

Hi I have a table which has a lookup based on another table. This look up is used in a form. I have a colleage who wants to hide certain values temporarily in the lookup field. i.e 'Work shop names' which are only available certain time of the year, so rather than have a big list to choose...

Oh, I see now. Thanks for your help on this one BOB.

Thanks BOB, it works great. The only thing I had to modify was to remove the = from the form properties. For some reason it flagged those as an error but otherwise that has resolved my problem. Thanks so much for your help! janeyg

Hi Gina I wanted to log the activity on forms as I want to reduce them but my boss feels they are needed so I wanted to monitor usage to see if this really is the case. thanks for your help on this one.

Thanks Bob, I will have a go at setting that up. Much appreciated! :)

Thanks for your reply - I will check the property

ok, I changed the name of my form, as that seemed to be bring up errors. So my code on click is now Private Sub Title_Click() DoCmd.OpenForm "frmResourcesbyStep", acNormal, , "[Title] = ' " & Me.Title & " ' " End Sub This brings up the form but takes me to a blank record and not the specific...

I wanted to log which users have opened and exited a form, I have 5 forms and wanted to log usage and users. Do you think this is possible?

No, I seem to get the run time error 2102 again. The form I am opening from is split form - even if I change the form I am opening to continuous instead of single - this error still pops up?

This is the code I have in the double click event in the form I am using to search for a record. The form I am trying to open is FRM_Resources by Step, as a specific record that matches the found Title (which is my primary key) Private Sub Title_DblClick(Cancel As Integer) DoCmd.OpenForm...

Hi David Thanks for your reply. I have added the code and done as you have suggested but I get the error message" run time error 2102" The form name FRM_Resources by Step is misspelled or does not exist ? I dont know how to get rid of this? And don't understand why it says my form does not...

Hi I am a novice when it come to codes and macros that are more than basic. I have two forms. One is a datasheet. One is a form with a default view of Single Form (which contains combo boxes). I want to have the user select (click) on a record in the datasheet and have the second form open...

Hi, I wanted to send a message to the person who created this sample database with a modification query but I don't have enough posts to do this, so my message would not send. The below sample database called Sample - Use Hidden Form to Log Users ...