Search results

h iall, my code is corectly writing to the first table and set of fields correctly, now i want to add the ability to write to a second table with a different group of fields. what am i doing wrong here? it all should be done on after update. Private Sub Form_AfterUpdate() Dim cnn As...

hi! ive attached a paint image of my next issue in this problem, how can i convert the "#num!" items to a usable number such as zero? this error or whatever it is, is causing me issues in the next query i need to write. please help!

alrighty, how can i get to the end result using a vba function?

also, could you elaborrate on the usage and implementation of the "NZ function" as you call it. thanks!

awsome great CDATE did it! now, how do i convert a medium or short time, to a general whole number like for example 3:20 = 200 minutes my purpose now is to be able to divide time by a quantity and then multiply the result to calculate time utilized please advise

im just about ready to shoot myself.... ive got this string of queries based on a table that use this function correctly. and i have a second string of queries based on a DIFFERENT table that will not work when i have the criteria entered. what am i missing? i think ive checked all the...

sorry to be buggy about it, need it in a hurry. also thanks for the reply! that seems to have worked :)

anyone able to help with this?

hi! thanks for the reply, i was able to get the difference in time to display. my next issue is that i to set my critera to do the following: i will have a seperate query for each of these 3 critera. 1) only look at records between 4:00:01pm and 2:30:00am on monday through thursday 2)...

hi! how does one go about subtracting an [start time] from and [end time] to get a total of the difference in a usable format such as minutes? i keep getting wild decimals when i try to do this. please help!

thank you for the reply. i cant have this set up in print preview. it needs to remain in report view. ok the not on timer thing i understand that, but i do need the report to continue to requery whereas maybe the coloring could then occur after its loaded or something? the values in...

hi all! im having some trouble doing some types of conditional formatting in VBA, let me lay out the scenario here and we can go from there. i have a report that requeries itself every 30 seconds as an updating display type of deal. there are forms within the database that contain pulldown...

that appears to be working properly for reports. thank you very much!

thanks, i will try that out. :)

1) im not sure what you mean 2) my reports refresh to display real time data on television screens, my database acts like a functional production planning/management tool, and reports provided the only method to display all of what i wanted to display. 3) i need the reports to remain open...

Option Compare Database Sub Form_Timer() ' IDLEMINUTES determines how much idle time to wait for before ' running the IdleTimeDetected subroutine. Const IDLEMINUTES = 0.6 Static PrevControlName As String Static PrevFormName As String Static ExpiredTime Dim ActiveFormName As...

my reports are running this: Private Sub Report_Timer() n = n + 1 Me.Requery End Sub this effectively refreshes my reports, and now i need to exclude reports from the inactivity code or somehow count the requey as user activity. please advise

ok ive got the thing going, now i need to exclude reports that i have that refresh idears?

that sounds exactly like what i need. though i am having trouble implementing that, ive been getting errors when trying to apply it. Could someone please set that up in a 2010 DB and post it here? thanks!

I have a zillion forms in my database and I needed to develop an automated kill-switch of sorts to handle some specific user issues. I’m open to other ideas, but the main purpose is to close forms and even the database based on user inactivity. i do not want this to effect reports however. I...