Search results for query: *

Good Afternoon, I am having difficulty finding how to remove the filter sort from a form on Access 2007. I do not have the product installed on my machine which makes it difficult for me to just play around to solve the problem. One of our applications has errors on the subtotals for the...

Good Afternoon, I have a head scratcher on my hands. I am running a procedure to update a field on a form whose data is derived from a stored procedure with variables. I can successfully get this procedure to run, but it would reset the form on my Me.Requery. My attempt in the code below was...

Zor, I have the text in the correct property for the button. Upon further investigation through the web. This appears to be a problem with Office 2003, though no one really told me how to fix it. The funny thing is that it works on my associates computer, just not mine. The reason why it...

Good Afternoon, I am building a form that contains command buttons that allow a user to perform an action to the record. I want a small message to appear helping them determine what each button does as I don't ahve room to label them. Going through the posts on this forum, control tip text...

Aceman.... Awesome! The oncurrent property worked. I have been working in databases for a while (forum/self-taught), and have never used that property before. Thank you!

Thanks guys... here is some more information I don't believe this is something that conditional formatting can handle, I will try the "on current" thing, but not sure what to do there... Here is the code that I am working with. This is the on click property of a button on the main form. Dim...

Good Afternoon, I have a main form that contains header level information. On this same form, I have a subform that contains the details regarding the header. What I would like to do is if a condition exists, I would like to lock down the individual fields of the subform. How do I do this...

Rac2 Thanks, I had that same issue you spoke of before and did pretty much the same thing you suggest to get around it. The problem I am having now has to do with rights. I gave a test user sys admin rights and the procedure worked under their login. I don't want to do that. I need some...

Good afternoon. I am going bananas with this problem. I have a procedure that extracts data and emails it out as an excel spreadsheet. I am reusing BCP code that works within another process and it works beautifully on my computer, but on our production system on any other user machines, it...

Never Mind... i figured out somethign taht works. I pasted the code in to a dummy form and added the function to open on open of the form... now it runs. Probably not the best thing to do, but it is workign.

Good Morning... I have an issue on the forms that I am creating in Access 2003, that didn't occur in 2000. Any time I create a form, the labels appear to trigger the screen to flicker. I have researched this on the net and found a work around, however, I cannot figure out how to get it to...

Wow... that worked. Why did it require the "select" instead of "set?" Should this be something I use moving forward when filling a variable with an agregated query?

I am expecting a number of assists from my select query to be populated in the @assist variable. The problem is I get the error I listed above. If I run the select statment on it's own, I get a result with a number, yet when I combine it with the "set @assist =" it bombs out.

Hi all, I am perplexed, I have the following SQL code and it runs fine on it's own, and returns only one result, which should make it OK for filling a variable that I have. Instead, I get the following error... "Server: Msg 8624, Level 16, State 16, Line 7 Internal SQL Server error." The...

I am not following, I need a little more description of how I would write this?

Hello, I am creating a process to retrieve 4 files from an FTP site, import those files into SQL and then update tables accordingly, after updating the tables, I will remove the files from the local directory and would like to remove them from the FTP site as well. I am retrieving files that...

The page setup properties do not state anything about the color or monochrome options. I have already formated the report to properly fit the page using this setting. My issue is that the property for color or mono on the printer is somehow inherited in the actual report. So if I had my...

Hello, I am currently faced with a delimma. My company wishes to have everything set up to print Monochrome to our color printer as the default. I have changed every user's default properties on the printers to be default, and most microsoft applications accept this, but in Access, the...

OK... I got it with this. I found an error in another variable I was passing. Thanks Denis... Like '%'+ RTRIM(@WildCard) + '%'

I got the right result with this: '''%'+ RTRIM(@WildCard) + '%''' The problem is that the query still won't pull anything. I ran some simple queries to validate... Select * from TABLE where FIELDNAME like '%tech%' this works. Select * from TABLE where FIELDNAME like @wildcard This doesn't...