Search results

You rock :) Thanks

I need to autocalculate the year for a query, so I don't have to update it on an annual basis. I can autoinput the date, but don't know how to just get the Year. Will Year() do the trick, and if so, what variables indicate how to go back 2 years (Year(),-2)? Thanks in advance

I fixed it :) Thanks for the assist

I agree - I was also confused. So, the "Count" function beneath the totals is supposed to return a sum of the rows returned, not the sum of the values within the rows? Is that right? But what if I identified the following in the query as the criteria. Field: ID Table: TableName Total: Count...

I want to count the results of a query for some group by conditions. So I put together a query and try to utilize the "Count" function in Totals, but it counts the total of the numerical value of the ID Primary Key, instead of giving me the total rows returned. For example, ID | Date | Value...

Is there a method in which data can be exported by a button click from Access to Excel and then Excel to automatically create a graph (perhaps by Macros?). Just wondering what other solutions people have implemented since the graphing system in Access is.. lacking. TIA Pat

Okay - It's working, the SQL is finally working. However, I would still like to remove the user prompted message that pops up when the DoCmd.RunSQL is executed. Any ideas? Thank you so much, your help has been invaluable!! :)

LOL - Okay, after changing the receiving field from number to text, I'm making some progress (slaps forehead, DOH!). But now, it's inserting "CurrentUser()" as straight text and not substituting the actual function value for it. Is there SQL syntax to execute a function previous to insertion...

Not quite sure, the latest error that I've got it down to - is it will execute the query but I get a "conversion warning error" which tells me, if I click Yes it will run the query but insert a Null value. The names don't have any special characters in them, since they are the secured.mdw names...

Yeah - he answered on the debug method, which I tried to no avail. I deleted both the other threads because I was duplicating my question over the wrong forums (I never noticed the Queries forum). Hopefully someone's expertise here will be able to help out - I'm just not having much SQL luck...

My SQL syntax is all messed up apparently. Access is not enjoying the line below (or the 100 other variations I've tried since). Can anyone lend an eye to see what I am doing wrong with the Insert statement? DoCmd.RunSQL("INSERT into [Table Name] ([Field)] VALUES(' & CurrentUser() & ')")...

Is there a way to change the column header colors in a list box? Thanks in advance :)

I'm using the following code to resolve my paths for loading images into an unbound field for display. Private Function GetPathPart() As String ' Comments : Returns the path part of a string ' Parameters: strPath - string to parse ' Returns : path part ' Dim strPath...

Yup - I needed the zeros. The paradox database we had converted from inserted nulls to equal 0. In our beautiful access application, a line of amounts end up with a sum, but need the $0.00 in order to work (if it sees a NULL field, it doesn't add). Thanks for the precaution though, you guys are...

Nevermind - Used and update SQL query. ;)

Weird question - I have a table full of empty fields I need to replace with the default $0.00. The Find and Replace doesn't seem to want to work because I can't enter "Null" as an option, or it will put the word "Null" in. Any ideas? Thanks so much :) Pat

I've added a delete button to my forms, now that I've gone with preview mode, to allow the users easy access to record deletion. This works on everyones system and the built in Access prompts are nice, because when you click the button it asks you to confirm the record deletion. However, on...

Thank you both! Once again, you've been a tremendous help. I do like the different colors in the background, gives it a sharp look :)

Last quick question - everything is running smooth and (most importantly) fast! I love the preview mode and the GUI program feel. There are a couple of places though where the users usually are able to delete records. Normally they were using the "Edit Menu -> Delete Record" method, but I had...

Any problems or changes with converting Access 2002 to 2003? Or is it as simple as the 2000 -> 2002 conversion? Just wanted to check, as I know we'll be facing this question in the spring. TIA Pat