Search results

Look below in Privat sub Reviewed_Click() I am getting an error at "[po]![subfrmpoinv]![amount] Po is the form ....subfrmpoinv is the sub form and amount is the field name. Can someone tell me what I am doing wrong Private Sub Reviewed_Click() On Error GoTo Err_Reviewed_Click...

how do I get bad response to the names in the table meaning if they put a wrong name in there how do I trap for that error? because now it not doing the else it is throwing an error wow I see my way does not work but your way does... now tho this part of my code is not working...

wow thanks for posting so quick I just may look at your option too~ :)

thanks!!! I ended up using If strSQL = Me.txtLogin Then

See below in comments what my problem is: Private Sub Command4_Click() Dim strSQL As String If IsNull(Me.txtLogin) Or Me.txtLogin = "" Then MsgBox "You must enter a User Name.", vbOKOnly, "Required Data" Me.txtLogin.SetFocus Exit Sub End If If IsNull(Me.txtPassword) Or Me.txtPassword = "" Then...

I have a form with a textbox and a button, when i type a value in the textbox and click the button I want it to check a record in a table for a value if it is then, I will do step A if it is not there then I am going to do step B what is wrong with the code below place code in on click event...

found a solution: http://support.microsoft.com/kb/132017 but thanks to all who looked at this!

Is there a way to code a text box that when you get to the end of the page to show totals for that page which mean every page will show totals just for that page. eample let say for page one there were 21 records and one field the data total 20 then on page two there were 35 records and the...

reply In our case we are not worried about the in between times we are just trying to get the first log and last logoff of the day and my test data was only set up to test for getting the lowest time and highest time of the day. I guess I did not looked at MELB problem as close as I should...

I can do it in One query MelB, Look at attachment and run and look at qrytotaltime........ You can get it done by using Min and Max if you got any question let me know. Greg

give this a try */11/* and */12/* inside that query

I have a table of date/time of logons and logoffs and users names. I have set up two queries one gets the Max time and the other gets the Min times. I have a third query that does the datediff to get the total time log on for a day(or rather it would be showing the time between first logon and...

r3df1sh, I am sure someone will come in with a better way than me but I would have a second query made that gets all the locations and I would have a button that would say all locations, now if they did not want all locations there would be a second button that would let them pick the location...

if you can add a field to Products, I would add a new field called tmonths put t with months because months maybe a key word then you will be able to link your months table with Products tables...but in the new field add in the months you want or need with each product then you should be able to...

FoFA...... My field name is contract and in my test case my table name is Table2..... it is giving me a compile error mid([Table2]![contract],instr(1,[Table2]![contract],"-")+1) I am place the above in the update of the update query what am I doing wrong

Do you not have Months in the product table you have two tables and Month is a table by itself ....do I understand that you do not have a month field in the product table?

I have a string of letters and numbers and I need to edit the string down example of data E-12345-A EE-12333-c T-34999 TT-22333 I need to have it search for a first dash and keep everything to the right of the first dash I need to get rid of the E-, EE-, T-, and TT- and so on so how do I...

thanks Wayne!

I place the lines below in the update area of the query and I get a type coversion error [-insp].[insp_nm] & Space(30-Len([-insp].[insp_nm])) & [cross_match].[employeenumber] how can I make this work its seems not to like the (30-Len..... if I put a number in instead of trying to minus it...

I have a program that will email reports, but how do I trap for when a report is null, so that if a report is full of null vaules that the program or code will not send the report that is null