Search results for query: *

Thanks Bob. I'll use your advice and create multiple txt boxes and hide them when certain criteria have been met. Thanks again!

Thought this would be an easy one, but I'm having trouble.... I have two unbound txt boxes (txtbox1 and txtbox2) on my form that both contain Value Lists. In both txtboxes, I have the column counts set to 2 Here's what they contain...(dummy entries) Row Source of txtbox1...

That did the trick. Thanks much!

I have a form called Dates (frmDates) that I enter a begin and end date into. I have a report linked to this form and I would like for these dates to appear in the report’s title (in the report header). When I use the code (below) in the text box’s Control Source, it works perfectly, but...

Looks like I had mistakenly placed the code under the Lost Focus event. That's why I was having problems. Now that it's back where I initially intended it to be, it works great. Thanks all!

Sorry to bring this one to life again, but I'm having a problem with the code. "Problem = problem & vbnewline & fosusername()" works the way I wanted it to, but it fills in the username regardless of whether or not the user makes an entry. So even if a user selects the field and tabs out...

Thanks again lupins46. Now if I want that entry to be bold, how do I do it using FontBold = True? I tried to add it to the code, but it bolds my entire memo field instead of just the username. Thanks

Thanks lupins46! It can be done...

I have a shared .mdb that is on a network server. On my form, I have a field called Problems (formatted as Memo)where users can enter data. This field is added onto quite a bit, as many users keep adding data underneath the prior entries (all in the same field box). What I am trying to do...

I have posted something similar to this back in Aug-Sept 2004 for my forms, but now I am trying to apply the same logic to my reports. I am trying to disable all fkey and ctrl functions when a user opens a report. I do not want them to be able to ctrl+s, or ctrl+f etc...and I do not want...

Thanks AceMan, Never thought of that, but I'll give it a try.

I have a button (button1) on my startup form that when clicked, will give me a report (report1). Now, I have several reports and would like each one to have it's own button. But, because I don't have enough room on my startup form, I have created another form that can accomodate all of my...

I have a form that contains 2 text fields to enter dates (Start Date and End Date) After the user types in the Start Date, I would like the cursor to automatically jump to the End Date box without having to use the Tab button. Not sure if this matters, but I have the input mask set to...

I am using Sybase SQL Advantage 11 and for some reason, regardless of the number of returned rows of data, it will only return data up to row # 32,760. In other words, if I set rowcount to 40,000 and run the query, it will tell me that 40,000 rows were processed. However, only 32,760 rows...

Like a charm.... Thanks for the explanation!

Sorry for having to reintroduce this issue, but the code that I used above works, but for some reason it does not allow my users to enter data into the text boxes of my Access form. As stated above, my objective is to freeze the "F" keys and any "ctrl" functions while users are in the form...

Roy, Thanks very much for your assistance. I'm certainly not looking to become someone who belongs in #10. Have a good one. INYH

?? I don't understand what you mean by F1 on KeyDown. Thanks

Thanks Roy, but this did not work.

I am trying to disable the Ctrl button while users are in a form. I do not want them to be able to use any of the ctrl + shortcuts for printing...find/replace etc.... I have used a similar code for disabling the F keys, but for some reason it is not working for the ctrl button. Here is what...