Search results

The method used to open a form is OpenForm(FormName, View, FilterName, WhereCondition, DataMode, WindowMode, OpenArgs) FormName is required, the rest are optional. The parameter you want to make use of is WhereCondition. You pass the record ID of the current form to the new form eg...

Fair point TJ, however the OP did say ..."It would also be preferable to do this "After Update" on the field itself..", so i did not see the need to clarify as i was addressing the OP's requirements.

If you try changing the value of a control in BeforeUpdate(), it will generate an error ..."prevent Access from saving the data in the field". It would need to be AfterUpdate()

You will be able to perform this in the AfterUpdate event(). Have a look at the DateSerial() function. mycontrol = DateSerial(Year(mycontrol),Month(mycontrol),1)

I am sure your current Users table would be fine. The actual recording of logged in or not is up to you. The Maintenance table is where you control what you want to happen with the database. So from an Admin panel (Maintenance form) you can see who has which objects open. You may want to...

MarkK, yes the report prints no problem. Welcome to my confusion. In the manual method, I/the user opens the report, clicks PDF or XPS on the Data tab of the ribbon, navigate to the preferred location to save and hit save. That is when the error message pops up BUT in windows explorer you can...

Well my first thoughts, do you receive an order from partner A for a ring and another order from partner B for a ring OR 1 order for 2 rings from partner A +/or B? You could have separate tables for customer details and orders but how many 'repeat' orders do you get (hopefully none:rolleyes:)...

The FE's are usually on the users desktop or in the C:\Users\Name\Documents folder. Access is run with normal permissions, eg you have to enable content first time you open. My biggest bug bare is how sometimes it works:D;):p:rolleyes::eek: and sometimes it...

I have created user monitoring systems in databases before. All you are asking is achievable. When you stop and think through the requirements, it is pretty straightforward. Tables: Users - for logging in In Use table - for logging which objects (forms/reports/queries) are open by which user...

I have reworked the naming convention for the outputted files to exclude any spaces and periods. I have used UNC paths also. FileName = "\\server\Company\Documents\Operations\Suppliers\Logistics\Shipper\" & Me.suppID & "\" & Me.suppID & "-" & Me.tbDest & " WK" & Format(Me.shpSail - 7, "ww") &...

Thanks Ranman, that is how i came up with the 2 SQL i posted. Will need to replicate this a few times, so wanted to avoid subqueries.

Hi Guys I am looking for a solution to delete records in one table where a field = a form selected value and the FK is also in another table where a field there = a form selected value. Setting: I have a join table (it creates combinations of Sites and Sectors covered by each Site). The PK is...

Here is a useful way to obtain the list of all the available printers For Each prt In Application.Printers MsgBox prt.DeviceName Next prt You would just need to change the MsgBox line to assign the value to a listbox or combobox for the user to select

Hi Have a look at Application.Printers() method. You can specify which printer to output to. Not sure if you can incorporate it in your scenario.

Well that's a pretty broad question. :rolleyes: If you can create it in Excel, you can create it in Access. You say What problems are you encountering? Data or aesthetics? Give us something to work with, an example of your Excel report.

Sorry for the delay in replying. I have to admit i am lazy and use LFS paths:eek: I have amended the code to use UNC but it still falls over:confused: is my outputto code correct? DoCmd.OutputTo acOutputReport, "ShippingForm", "PDFFormat(*.pdf)", FileName(), False, "", , acExportQualityPrint...

Cheers Ranman for the suggestion. I have just checked and the PDF reader is not open in Task Manager.:confused: I also just tried saving to desktop and that works! Further suggests network/server issue?

Hi everyone. On several reports on 2 different databases, users are getting "The Output to Action was cancelled:2501" message when trying to save a report as PDF via OutputTo action. Equally when trying to manually save as PDF they get "cant save the output data to the file you've selected" (on...

Of course you could always do the analysis in Access. Either look up the formulae(s) and create custom Functions OR look for purpose built add ons (eg http://www.fmsinc.com/MicrosoftAccess/StatisticalAnalysis.html)

Post what you tried. If i can't help i am sure someone will.