I realise that MDE and MDB files are not the same but in terms of comiling a database you would think that if something is working as a MDB file that when you come to create an MDE file it should also work.
The query I created is held within the database whre I have the code. The backend has already connected. I did how ever add the command to test and I still get the same issue. I can't beleive such a straight forward command is...
Blaize
Last Activity: Mar 18 '08, 12:48 PM
Joined: Nov 14 '07
Location:
-
...but in answer to your question, adding in the line of code Call MsgBox(Now()) it displays the date & time, click on, then you get the error message,
Cheers,
JamesLeave a comment:
-
Hi,
Nah its not the Now() function which is causing the issue I've replaced Now() with todays date. Compiled, saved works fine as a MDB file, build to an MDE file and get: "The expression On Click you entered..." error. Tried loads of things to get round it, even a query with all the 'If' statements etc and still get the same error. Either something really basic or critically wrong which is causing it to fail. What I...Leave a comment:
-
Hi NeoPa,
I've using Visual Basic with Access 2000 so Code:(Text) does not work. I tried your other and it bring a message box with the date and time, so not sure what thats trying to resolve? I know the line which causes the error message its the line where I'm passing a parameter to a query, which is line 9. Just wonder if its something simple which I've missed that the complier isn't picking up??
Cheers,
...Leave a comment:
-
What I've done is to comment out all the code and this is the line it falls over at. I've never had this issue before I've checked my references and DAO and others are listed, like I say everything works perfectly as long as you don't generate an MDE file, really weird!? Problem is it needs to be built as an MDE file as 30-35 people will be using it... nuts!Leave a comment:
-
Have got one final issue though! Works fine at the moment in development as a MDB file. I've compliled and saved then created an MDE file for distribution and get the error: "The expression On Click you enetered as the event property setting produced the following error: The expression may not result in the name of a macro, the name of a user-defined fuction or [Event Procedure]. + There may have been an error evaluating the function, event,...Leave a comment:
-
Scott, ADezii, Thank you both so much it works a treat...your both life savers! here's my amended code...
[CODE=vb]
Dim MyDB As DAO.Database, MyQD As DAO.QueryDef, MyRS As DAO.Recordset
Dim intTotalMinutes As Long, intHours As Integer, intMinutes As Integer, intNewTotal As Double
Dim intRunningMinut es As Integer
Set MyDB = CurrentDb()
Set MyQD = MyDB.QueryDefs! qryDailyDevStat s_Output...Leave a comment:
-
Sorry maybe I'm not being clear, I'm trying to add multiple time figures together to get a total figure.
00:15:00 + 01:15:00 = 01:30
The data i have is split into three sections, Team 1, Team 2 & Team 3. I'm trying to get the total time figure for each Team. This isn't a problem at the moment for Team 2 and Team 3 as the total number only goes up to 11:00 and 07:15. Team 1 should be about 37:45.
...Leave a comment:
-
I did think about that but I'm having issues converting, for example one line in the query is "00:15:00" (which is 15 minutes) to an integer value 0.25? If I could do that then I think I can crack it.Leave a comment:
-
I can't get that to work, the data is coming from a query which looks similar to below but more data!
User anOrder Time
A 1 00:15 (15 Minutes)
B 1 15:45 (15 Hours 45 Minutes)
C 1 13:30 (13 Hours 30 Minutes)
D 2 05:00 (5 Hours)
E 2 00:30 (30 Minutes)
F 3 03:00 (3 Hours)...Leave a comment:
-
Calculating Time Query
Hi,
I'm having an issue trying to calculate time. Its okay if the value does not exceed 24 hours otherwise I get a date and hours listed. For example, I have a loop which looks through a table and adds up the time spent.
...Code:Dim TempCount As Date Dim DEVCount As Date Do TempCount = rst!wtime DEVCount = DEVCount + TempCount rst.MoveNext -
Hi thanks for the reply, unfortunately both the front and back end default open mode are already set to shared. It’s bizarre as it works fine over the network just in Citrix we have the issue.Leave a comment:
-
Running MDE file over Citrix
We are having locked database issues with having an MDE file which we added for our Citrix users. The Citrix users are added to a specific group in Active Directory which allows them to access the MDE file. Works fine for the first person to access the MDE file, if someone else connects up to Citrix and clicks on the shortcut they get a message advising the database is locked out.
We have found that adding the MDE file into a couple...
No activity results to display
Leave a comment: