Search results

I have a form that is maximized. I have a button in the form that would open a report in preview. The report opens as maximized but when I close that, the form that called it is now in floating/windowed mode. Putting Docmd.Maximize in current event does not maximize the form. Even the gotfocus...

Good day to the very helpful members of Access World! We have some forms with web browser control that shows the pdf file for a specific selection from a list box. For security reasons, the management wants to disable saving a copy and printing capability of the pdf being shown. Is this...

Hi all! I know this is simple but I cannot make it to give me the result I need. Say I have a table like this: How do I make the query not to include record 4 with all 0's in fields Number1, Number2, Number3 and Number4? I tried this: SELECT tblTemp.ID FROM tblTemp WHERE...

Our database has a table with ole object field. Stored in this field are photos of employees. Users insert the photos by copying in Word or Excel and pasting in a bound control on a form. This used to work fine. When we upgraded to Windows 10, photos cannot be inserted anymore using the form. No...

Let's say I have 2 tables, tblProcess and tblWeld, as shown in the figures below: How do I create the sql so that what I get in ProcessA and ProcessB is the corresponding ProcessCode without doing DLookup?

I am currently updating a project I inherited. I am trying to simplify some of the queries and I come accross this: SELECT DISTINCT DWR_1.NDEQRNo, DWR_1.ID AS RecID, DWR_Spools.ProjID, DWR_1.StatCode, DWR_Spools.DwgNo, DWR_Spools.SpoolNo, ([DWR_Spools]![WeldNoPrefix]+"-") &...

I want to do late binding on an Excel application object but I am having an Error 1004 (Unable to set the WindowState property of the Application class) if I do it that way. The code runs fine when the Excel object library is referenced. Dim objExcel As Object Dim objWorkbook As...

What is wrong with this code? I am finding the last file backup with date in the filename e.g. Filename_(2020-01-23).ext. I can extract the date expression from the filename but when I try to change it to date, it gives a different date. The code below is incomplete just showing the relevant...

First off, I am sorry for the confusion I inadvertently created recently with all the thanks that I purportedly given to posts. Even I was taken aback with the PMs I received about this. At first I thought my account was hacked. When I looked back to what I did the last few days, I realized...