Search results

Thanks Fifty2One. Here's where I get lost. The command button on form A opens form B where the link criteria is the PO and item match. stDocName = "frmIssues2" stLinkCriteria = "[PO#Line#]=" & "'" &Me![PO and Line] & "'" If there is a match then form B shows the correspondence that has...

I have a continuous form that shows quote information for a geographical area. On this form is a command button that opens a form based on a query based on a linked table from another database. The related field is purchase order item number. The form shows communication between the company...

I have a large table (over 20,000 records) where the text fields were all set at 255 - even those requiring a single character entry. Is there a way to determine the highest existing character count for each field so I can set the text fields to a reasonable setting? After a compact and repair...

Bob, The button works great! Thanks.

I have a form for table data enrtry. Data entry using this form will take place during a phone conversations with customers. One of the fields I would like to capture is the date and time of the call. If I use the Now() function the date time changes and does not fill in the field on the...

OK. The dcount provides the total records in the query for the top half of the calculation. How do I get Access to display the current record number as a filed? I tried setting up the query as a make table with an autonumber which worked fine the first time but this table must be deleted and...

I have an Access query that lists completed company forms by days to complete in descending order. I want to use the reccord number and total record count to present the percentage of forms that were completed at each completion date. Ther purpose is to quickly show that 80 percent of forms...

Transferred xls files do not overwrite Bob, I'm a little confused. Here is my existing code that trnasfers fine but does not overwrite the files. Where do I place your code? Function mcrSend_Efficiency_Reports_REVX() On Error GoTo mcrSend_Efficiency_Reports_REVX_Err DoCmd.SetWarnings...

I have an Access application where a macro transfers two spreadsheets to a designated directory. This works fine if the directory is empty but if old files are in the directory they are not overwritten. Is there a way for the transferred files to overwrite the existing files in the directory?

Query by form for report How do I do that? The form is just a combo box with OK and Cancel buttons. Teh combo is attached to the paramer of the query. The open event on the report opens the form so I'm confused as to how I would open the form first.

I have a report that I would like to pass parameter information by form. I have created the form and placed the parameter information in the query [Forms]![Form Name]![Field] and placed the following code in the open event of the report: Private Sub Report_Open(Cancel As Integer)...

I use SAP output to Excel to Access back to Excel each day and I have to agree with Brian. Sometimes you just have to use the correct tool for the job and Excel is much quicker and better at formatting SAP output than Access - especially if you have to reformat dates. So, push two buttions -...

Rural Guy, Your solution worked perfectly. Thanks!

I have an Access table with a field called Purchase Oreder Item. The field must be all numbers and the length can be from 10 characters to fourteen characters. I have no problem requiring all numeric characters with a validation rule and setting a maximum length with the input mask. The...

I have a database form that uses a check box. The following code is used to go to the next recod upon clicking the check box. DoCmd.GoToRecord , , acNext The problem comes when the check box is clicked at the last record I get a run time error 2105 "You can't go to the specified record". There...

I have a workbook where sheet 3 is updated each day. Sheet 2 contains the daily frequency by hour from the time column of sheet 3. I would like a macro to calculate the frequency and fill out the daily colun of the sheet each day. I can record the macro to do this but it wants to fill in the...

I have a macro that transfers spreadsheets to sixteen folders. Each has a distinct name and directory. The problem is that this is done daily and the spreadsheet will overwrite the previous days entry. Is there a way to automatically insert the current days date into the file names? For...

I have a form with a check box that controls a report which sends faxes to appropriate recipients. When the form closes I would like all check boxes to clear so the next time it is opened I can select recipients. Currently I have to deselect each check box one by one. A control button which...

Thanks everyone. Here's some additional information. The main form is created from a SAP download each week. The previous week mainform has all recoreds deleted by a delete query. So, the comments cannot be part of the main form. No, there is only one comment per main form record so it...

I have a form where the users view many fields but can only edit a check box - click to check. The problem is that the last check box clicked shows checked but the record is still in edit mode, so the operators open the report showing all records except the last one checked (clicked). Is there...