Search results

thanks for the input guys i have it set on a 30 second interval to requery but the user complains that its creating to much network traffic.(which it is)i wish these users would realize lifes a balancing act.They want it both ways,speed and 100% bullet proof,even want buttons to tell them if...

Is it possible to requery a form on one pc from another pc connected on the network at the moment the user has to click a refresh button to refresh the screen with up to date data.If a user on another machine makes changes is there any automation that would update all pcs that are on the network...

sets the recordsource of the text box on the report to =forms![yourformname]![Textboxname]

Thanks Mile-O-File that worked a treat

could anyone please tell me what criteria to use in a query that would return all order dates that were made today, when the table holding the dates is date/time format i am trying to find any orders that were placed to day regardless of what time they were placed.i tried using date() but that...

Try this StartDate: IIf(Weekday(Date) = 2, Date, IIf(Weekday(Date) = 3, DateAdd("d", -1, Date), IIf(Weekday(Date) = 4, DateAdd("d", -2, Date), IIf(Weekday(Date) = 5, DateAdd("d", -3, Date), IIf(Weekday(Date) = 6, DateAdd("d", -4, Date), 5))))) That would give you the start date for your print...

try creating a new db and importing all the objects,perhaps the db is corrupt

open your form code module make sure you have at the top of the module option Explicit click compile and see if the code compiles ok that may give you a place to start

Jerimie all this stuff is way over my head but i am willing to try anything using your method ,if i know the file name and the folder name and the file ext, what would the syntax for the Dir() function

i have asked the same question,but alas nobody seems to know of a faster way to search. or if they do they are keeping it to themselves i am using access 2000 and have the same problem. the only thing that speeds up my search is to keep moving old files out of the folder that i search to keep...

line input does the job, i can at least open the file and read it, thanks for the help now i get to question 2 do you have to read every line to find plabel=1 or is their a function that can be used to search the file.In notepad you can use find and its very quick,in access reading every line...

i am trying to read the file, i have tried output,input,random , i may have forgot to change output the last time, it just doesnt seem to make a difference, when you step through the code it finds the file,opens it then jumps to eof and closes the file i am not sure of the difference between...

i am trying to open a file to which has some cnc machine data in it,but cant seem to crack why or what i am doing wrong i need to open this file and search for data that confirms that the machine has actually performed its task. i have 2 questions 1.what is the most efficient way to search...

why dont you create the query using the access wizard then look at the sql view,it will give you the correct syntax for the query

try and use a select case in the forms on current event dim MyMonth as string StrMyMonth=left(me![textboxnamethat holds july etc],3) select case StrMyMonth case "Jan" me![othertextboxname]=1 case "Feb"...

are the controls you are referring to subforms ([Forms]![Main form]![P1]![Port 17 loss].form)

if you have to check several stock items then you will have to approach things differently you could either directly scan the table or set up a query to return records whose stock qty was less than the minimum qty I would use a query Dim Dbs As DAO.Database Dim Rst As DAO.Recordset Dim Qdf As...

with out knowing exactly what your table structure is you could try Dim MinAmount as long MinAmount= 10 ' or whatever your min stock amount is if DSum("[field that holds stock qty]","[yourtablename]") < MinAmount then beep msgbox "WATCH OUT, STOCK ON HAND IS TOO LOW, PLEASE REPLENISH...

try "select count(*) from [Tasks] where [SerialNumber] =" & """" & strTo & """" & " and " & _ "[Task No] = " & lngTaskNum & " and [TaskName] = " & """" & strTaskName & """" & " and [Type] = " & """" & "Insp" & """" & "," or you could declare a variable Dim StrQuote As String StrQuote = """"...

not sure if this is what you want but you could try adding code to show the toolbars that you removed ,when you close the database DoCmd.ShowToolbar "the toolbar name", acToolbarWhereApprop