Recent content by SteveL

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...

So far I am not able to make anything work. I tried both replies and can't make them work. Can anyone help?

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...

Access 2013. I have tried what you suggest and I enter the server name but it doesn't work. I have the table (just one table) on my SharePoint server but I cannot get the front-end file to link to it.

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

JDraw: The database is a actually a stripped down version of the original database due to confidentiality issues. The original is normalized. Plus I'm sorry if I didn't explain the issue well enough. CJ London: I don't know how to do what you are suggesting.

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...

Did you ever resolve your issue with hi-res pictures looking terrible in print preview mode? I am having the same exact problem.

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...

To further explain... The report now looks like: Part # Due Date FG Qty 12345 1/31/2010 1 12345 2/10/2010 1 Any I want it to look like: Part # Due...