Search results

I am working with a database that someone else set up, that has an input mask for a phone # field. It works fine for US numbers, but we are running into some international #s as well, and it is not working with these #s. Is there a way to set up the input mask to select either format, based on...

I have a button on a Form that runs some code to update a couple of fields, and then I would like the curser to automatically got to a field in a sub-form. I am not having any success in getting the control to a Sub-Form Field. Any Help?????

I have data from a Query that I would like to put into a formatted report in Excel. When I do the Export, is there a way that I can specify which cells the information from my query will be placed in?

I have a report that, for too many reasons to explain, I have been asked to put into Excel. I have quite a bit of structure/formatting in my report, so a straight dump will not due. I was told once that I would need to make a template in Excel that would be called up whenever I needed to run...

I have a very strange problem that I can hardly explain. When I am opening my 'Main Form' the information in the Sub-Form is not coming up (It's not linking properly). However, when I go into the Design View of the Main Form, and then back into the Form View (Without making any changes) the...

Is there a way to set an Access Report to fit to one page (similar to Excel)? Depending on how many records in my sub-report, my main report can be multiple pages, and I would prefer only one. Thank you,

On a Purchase Order, there may be some instances where it is revised, and some of the items can be cancelled. I am showing items are cancelled by adding an 'Item Cancelled' button for each item. When this button is {Active}, and an item is cancelled, I would like that item to stay on the PO...

I have a subform, that I would like to automatically size to the amount of records it is displaying. When I set the [Can Grow] & [Can Shrink] options to 'Yes' for the sub-form, it does not have any affect on viewing the form, but will affect the printing of the form. Any suggestions????

When I select a choice from a combo box on a form, I would like the form to go to the record specified in the combo box. I tried to use the: [docmd.GotoRecord,,acGoto] But I don't know how to identify the record of my choosing by its record number. Any ideas????

I am using the docmd.sendobject command to send a report as an .snp file. What I would like to do now, is to send .snp files for two reports. Can I do this with the sendobject command?? My code is: DoCmd.SendObject acReport, stDocName, "SnapshotFormat(*.snp)", , , , stSubject Thank you

I have a database that I would like to set up three levels of security (something I have never done before). Admin: Would have full permissions to modify anything in the database. User: Would have permisison only to enter data, use command buttons, view and print reports. Viewer: Would...

Can I tie several option buttons on a form, into a single field in a table (i.e. depending on which option button is selected, that will set the value in the table & visa versa)? Thank you in advance...

I have run into a wall, as far as the number of 'options' I can have in a critera option. I am in a loop, pulling information out of a table, and I want to insure that I do not pull information for the same record twice, so I am adding the Key Field to the Criteria after each pass (see code...

What I have is more of an annoyance than a problem. I have successfully added/edited a chart to my report. The annoying part, is that when I go to format the chart (Using Microsoft Graph), it doesn't reflect the data that my chart is based off. In order to preview my changes, I need to...

I am using the DLookup Function to pull data from a table (see below), and now I want to put that data into another table. tempCompletionDt(z) = DLookup("[Mfg Completion Date]", "[Project Status - Tbl]", criteria(x)) I am able to do it using a Form as an interface, but I am sure that there is...

I have some code that is opening a form, getting date, closing the form, opening another form, pasting the data, and then closing that form as well. This step is repeated about 12 times, and watching the screen flash can give a person a head ache. Can the code be set up, so when opening &...

I am opening a form based on given criteria (the form is based on a query). There will be either one record for the given criteria, or no record. When there is no record, I get an error "You entered an expression that has no value." Can I check to see if the form/query will be empty before...

I have a chart in a report, where the data in the query that the chart is based from is currency with 0 decimal places. I have selected the 'Show Data Table' for the chart, and when I Preview the report, the data is not formatted properly. I have verified my data source, but am getting nowhere...

I have a chart in a report, where the data in the query that the chart is based from is currency with 0 decimal places. I have selected the 'Show Data Table' for the chart, and when I Preview the report, the data is not formatted properly. I have verified my data source, but am getting...