Search results

I have a hyperlink field on a form that when clicked opens the PDF file that is in the text field. The PDF file opens for display just fine but doesn't stay on top. The Access form stays on top. Can this be resolved so the PDF stays visible and not behind the Access form? Here is the...

I have a subform currently that is in continuous form mode. But there will be up to 36 records to display and we don't want to display all 36 of them in one continuous form. So I thought I would creat 3 command buttons on the main form. The first command button will display the first 12...

Is there a way to record an audio file when a command button is clicked on a form? And then once the audio file has been recorded, make it a part of the form's record? Maybe as an attachment of some type? In other words, the user clicks a command button, an audio recorder opens, the user...

I have successfully migrated a simple Access backend table to my SharePoint site. But I cannot figure out how to link the table in SharePoint to my Access front-end. Can anyone help? --Steve

Please see the attachment. Note that the sub-form on the right-hand side of the form that opens when you open the database has 4 line records. Obviously the sub-form is a continuous form. What I am having trouble with is this... If I delete the record that is red, (the top record), I get a...

I have a parent form which has a yes/no checkbox in the form's record source. Then in that parent form I have a sub-form. If NO records exist in the sub-form I want the checkbox to be UN checked. If records DO exist in the sub-form, I want the checkbox to be CHECKED. But I want this to...

I have the following code in the afterupdate event of the man form. Basically if a change was made on a field on the form a form named "frmRevisionHistory" opens. But if a change was made on any of the 3 sub-forms I want the form "frmRevisionHistory" to open then also. But, and here's the...

I have a report which contains a sub-report. The sub-report contains an image block. The images can be either jpg or png and come from a network share. When I actually print the report the pictures look great. But in Print Preview mode they look terrible. They are "polarized" if you can imagine...

I have a list box on a form and want to do the following: 1) If the user double-clicks on a specific record in the listbox, have a 2nd form open right to that selected record. or 2) If the user double-clicks in the white area below the displayed records, have the 2nd form open to an empty...

I have a form which contains a combox box and a text box. The combo box allows the user to select a record from a table. The text box allows the user to enter a new job number. The key field in both the linked table and the resulting table is "JobN". "JobN" is actually a text field. Also on...

I have a report which lists records sorted by part number and then by date. Also on the report for each record is an inventory qty. So the first record may show part #1 due 1/31/2010 and display an inventory qty of "5". If the next record on the report is for the same part number, regardless...

I have an append table query and can't figure out how to append the records to the table being appended if: 1) The data in and one of three fields, named "Ack_Date", "Resch_Date", OR "Ord_qty" has changed from previous records appended to the table or if, 2) The record is not currently in...

For whatever reason I cannot get debugging to work. But let me say this... if I put the following code in an onclick event of the field, "txtCombinedCbxRecordInfo", which is the field I am trying to populate with the oncurrent event of the form, IT WORKS!!! Here is the code that is workig on...

I have a form named "frmJobCards" which is bound to a table named "tblPartsMasters" On the form is a listbox named "List1". This listbox is bound to a table named "tblCbxNumberData". Each record in the table named "tblPartsMasters" can have more than one associated record in...

I am trying to make a checkbox on a form check (be true) if a certain folder on the C drive of the user's computer exists and if any jpg files are in that folder. The following is my code of the on current event of the form. But it is not checking the checkbox when jpg files do exists in the...

I have a form and the form's control source is "tblProjects". By default the records are shown in ascending order by "ProjectID" from the table. But I'd like to add a combo box to the form which when the user clicks the drop down arrow, "ProjectOwner" from the table appears. I know how to...

I have a form named "frmOpenOrders". On this form is a field named "txtOrder_Qty". I am trying to write code for an afterupdate event of this field to do one of two thing: Scenario 1: If values DO NOT exist in ANY of 5 fields in a totally separate table named "tblPartsMasters", then I want a...

This is going to get complicated I'm sure. But here goes. I have a table named tblPrices. I have another table named tblPartsMasters. Both of these tables have a field named "Part_No" which is the index field in both tables. Then I also have a form named frmPartsMasters which is bound to...

I'd like to add a command button to my form which contains a listbox. When clicked I'd like all records to be selected. How can I do this?

I have a form which contains a listbox. It is a multi-select listbox. And I have a button on the form which runs a report. But I want the report to only show the selected records from the listbox. The report gets its records from an underlying query. But how do I make the selected records...