Search results for query: *

Hey folks, I am getting the #Valve error message in one of my formula's and after doing some research, I cannot determine where it is coming from. The formula starts of with the "=--if(" so I as some people sugguested, I tired to replace the -- with Sum but never had any luck. The formula is...

Good day, It is something really weird going on with the code below. I am tring to validate textboxes on my form. But what is happening is that if I leave any or all of the textboxes blank, access skips my code validating empty boxes and jumps right into the sql down below. Any ideas on this...

Good day, I want to have a date format of MM-YYYY on my textbox on my unbound form when the user enters the information. I have searched everywere to find the anwer but I can't get it. Any advice would be great. Thanks

Hey, Anyone have any advice on how to run an excel macro from Access. For example if i have the file open in excel and I want to jump from Access to excel and run the macro. Any ideas would be great thanks

Hey, Anyone know how to delete the contents of a table through VBA or a macro? Any help would be great. Thanks

Hey everyone, I have a query setup and I only want to return that last three rows of data from the table. Anyone have any advice on how to set this up? I am aware of the the SELECT TOP 3 but not sure if it is possible to just bring back the last 3 records. Thanks

Hey, Anyone know a good access vba book for beginner's? Note: I am new to vba. Thanks

Hey, Anyone know the property to enlarge the bar's on charts.I was thinking options under the Format Data Series but that didn't work. thanks

Hey, Just wondering if anyone can notice a problem with this expression. I am getting an aggregate function error. Expr2: Sum([tblstj]![acd_calls]) / [tblstj]![acd_calls] Thanks

Hi everyone, I have a crosstab query created and when I run it I get an "Overflow" Error appear. Anyone have any ideas why this is happening? Thanks

Hey, Just wondering if this is possible. I have two queries with two fields in each. These queries will consistently have 48 records in each. Is it possible to export these two queries into excel on the same worksheet "side by side"? I would assume VBA would be used. Any help would...

Hey, Just wondering how do you disable the close button on a form. I have set the Close Button property to No but that did not work. Any help would be great! Thanks

Hello, I have a textbox bounded to a field back in my table. I want to place a command button next to the field to automatically populate today’s date. I have tried txtdate.setfocus txtdate.text = date but this do not work. Any ideas? Chris

Hey, Do anyone see any problem with this code. MsgBox "Your record has been sent to the database" If rstblAllMarkErrorUpdate.RecordCount > 0 Then On Error GoTo Err_Command26_Click DoCmd.GoToRecord , , acNext Err_Command26_Click: Select Case Err.Number Case 2105: MsgBox...

Hey, Do anyone see any problem with this code. MsgBox "Your record has been sent to the database" If rstblAllMarkErrorUpdate.RecordCount > 0 Then On Error GoTo Err_Command26_Click DoCmd.GoToRecord , , acNext Err_Command26_Click: Select Case Err.Number Case 2105: MsgBox...

Hey, I am creating my query and when I use the following criteria Between [Start Date] And [End Date] The query do not return any records if I use a single date. IE 5/27/03 But if I use 5/27/03 to 5/28/03 then it returns records for both days. Any ideas? Thank you

Hey, I have a data entry form with 10 textboxes. When I enter data in the 3 or 4 boxes and hit the tab key 8 or 9 times my record automatically moves on the next one. Do anyone know how to prevent this from happening? Thanks

Hey, I have a query created using two tables. When I run the query it prevents me from updating any records. Any ideas why this is happening or a way around it? Chris