Search results

hey guys i have the following code for a check box to reset to false when all my options on the form are cleard but i keep getting an error Me.chkAUTO.Value = 0 any help would be great

Sorry guys still having problems have it working that i can go for greater than the text box but i only want to do that if check box is ticked otherwise return all records. Below is my sql can anyone help please SELECT INVHTBL.INVH_ORDER_NO...

nevermind guys all good sorry bout that

hey guys i have a query where i want to return all values with a difference greater than a value entered in the user. Now DateDiff is working fine for this but the only problem i am having is if i set it to > FormTextBox nothing is being selected but if i actually put in a number e.g > 10 in...

bob, so is there anyway of when a user chooses a date it defaults to a specific time i.e if they choose 31/07/2007 it is 31/07/2007 11:59:59pm rather than 31/07/2007 12:00:00am? I have been looking for last couple days and cant seem to figure out how. Thanks Jason

bob thanks that does help just now need to figure out how when a user enters a date to return it as the date time field to the query as i dont wont user to have to worry about entering the time field in thanks again

hey i have a query that depending in a radio box filters by two seperate date fields one is a short date (update date) and one is a long date time field (timestamp) when i choose to filter by (update) all is good but when i choose to filter by (timestamp) it excludes the 1st and last day of my...

as per usual once i post on here the answer comes to me sorry bout that guys.

hey guys sorry to ask this as i know its probably really easy but being a newbie jut having trouble figuring it out in the below code i need to put the value of the txtPATH text box into the connection string and i cant seem to every code i try is just return the actual text of the code any...

got it hey guys nevermind got it:) search function may take awhile but it is worth doing here:)

ok guys not sure if to post this here or under queries but i am having trouble writing code to update the odbc link on a passthrough query. any ideas would be appreciated. thanks in advance

ok gemma just put exit sub in after the first case statement and still taking as long. the query it is looking at does have calculations in it and can vary in size from 2 records to over 5000 but no matter what the size the query still only takes 15 seconds max to run and even putting the exit...

gemma i have run both sections by themselves in the report and both ways are taking the same amount of time to open the report so i dont think it is an issue so much with running pretty much the same code twice and as the query only takes 15 seconds to load through the query viewer be it a few...

gemma the part on report load is for the headers and the part on report open is for the data. yes the report is based on a query but the query itself only takes 15 seconds to run where as the report takes 2 mins miniumum any ideas would be great

hey guys i have the following code for a crosstab report which all runs ok just extremley slow (like 2 mins) to open where as the query the reports is based on takes only about 10 seconds listed below is my code for that report any suggestions would be appreciated. Option Compare Database...

ok boys and girls i have 2 cross tab queries 1 returns cost of goods on an item for different locations the other returns qty on hand for that item for each location is there a way i can put both these onto the same report under the same location heading?

thanks adam that worked so was itthat the end if and next where round the wrong way?

ok guys so i have put this in my code Private Sub cmdRESET_Click() Call myReset End Sub and i get argument not optional message????

aje i tried your idea and i am getting a type mismatch where u type in Call myReset(me.name) is myreset there the name of the function or the module? as the module is named modreports and the function is myreset so in other words do i make it say call mymods(me.myreset) ? cause if you do...

ok guys i really am a complete newbie at vba and programming in general i have found a public function on a website to reset any list or combo boxes on my form and i just need to figure out how to call this from a command button on any forms i want the code is as follows Public Function...