Search results

well spotted, when ran now the filter does clear , but when the form is re opened the data from the command goes back in. i thought the data brought in would be a one shot and when the form closed it would clear. I am thinking of putting the code i have in the open parameter into an autoexec...

That doesn't seem to work either, I tried the code below and the data is there before and after the me.filter="". which im finding confusing as i thought when i sent the command it was to setup the filter. Dim filterval filterval = Me.Filter MsgBox (filterval) Me.Filter = "" MsgBox (filterval)...

hi gasman the data from the command input does stay the same, i was using the msgbox for debug and whatever data comes from the link stays on the form. I was trying to clear the command after it had opened the form but could get that to work

thanks for the reply arnelgp, i tried that and still didn't work the command data still stays resident

Hi, Hope you are all ok. I've made a form that sends out an email to named members about an issue they have to look at. The email contains a link to a database which opens a specific record, this is ok. The issue I've noticed is if you shut the form down , when you reopen it it still links to...

Hi Gasman thought that was another way to look at it so tried a batchfile with the whole string that i know if i drop in window explorer opens the form in the database and the result i thought strange. I made the batchfile below to open the form start "" "C:\Program Files (x86)\Microsoft...

Thanks for the reply extra cover...again this partially works if i remove the /cmd frmDevReq part it will open the required database, if i dont it gives the error cant find C:\dev\deviationdatabase.accdb /cmd frmDevReq Dim myfilelink As String myfilelink = "<a href='" &...

HI, you're right about the vbNewLine, it doesn't go on a new line , both links are on the same line

Hi Gasman thanks for your input again , I've made a bit of progress by using the following i get two separate links, the first opens access and the second opens the database ....but issue is the /cmd is getting ignored as well as the form name. looks like the link doesn't like spaces or filling...

Minty/gasman , those links has kinda got me there thanks if i drop the following line into windows explorer "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE C:\dev\deviationdatabase.accdb /cmd frmDevReq with the below sub in the onload of the switchboard ...the resulting...

Thanks for the info minty and gasman..kinda got it going now. I can open the database just need to figure out the code to open the specified id number Dim appOutlook As New Outlook.Application Dim objEmail As Outlook.MailItem Set objEmail = appOutlook.CreateItem(olMailItem) With objEmail .To =...

Hi dbguy, could you explain what you mean by the outlook side please. What im trying to do is automatically open the database from the link on the email (which i can do with a button on a form) instead of the user opening the database and searching for the id number after receiving the email...

Hi, i have some code I'm using to send an email to a user indicating that a database needs their input . What I've been trying to do as an extra is have a link on the sent email that when clicked opens the form that needs viewed. I have used the code below to open the database form with the...

hi jdraw, the idea is that they log in each day and a form with a safety message pops up and after they read it click a button and it saves it. if i can get the table checked each time they logon then a message will appear to say that a day has been missed and to update . When the update form...

hi dbguy thanks for the reply, do you mean use Dcount on a form in a text box and count the values in a column? IntX = DCount(“[expr1] & [expr2]& [expr3]& [expr4]& [expr5]”, “tbl_logon”) ill give this a go ...ithink it ignores nulls and should only count a field with data

Hi , ive put together a database that records when a user has viewed a safety message for the day and also the ability to update the database if they miss a day by using an update form. What ive been trying to do is have the user notified on logging in that they have missed a day on a certain...

arnelgp, it looks like you've got it bang on, the fails/passes match in the join and the report is working to sowing the current hour and the rolling hour yields, thanks for your patience with this, definitely learned a bit there about cleaner coding thanks again Here's the db if anyone's...

arnelgp, i tried the code in both queries i still get 0 coming up in the hour column instead of each hour that was logged

hi' ive attached a minimum database of the issues ive been seeing

Hi arnelgp, when i ran that query instead of getting row for each hour with the passes all that was returned was