Search results for query: *

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...

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...

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...

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...

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...

I would like to disable all of the F keys, in particular the F1, F7 and F12 keys. I have tried the code (see below), but it is not working properly. I'm not sure whether or not to use the code on the KeyPress or KeyDown Event. If I decide to use the OnKeyPress, I would need the Ascii code for...

I have discovered that you can disable many of the views in the properties section of the form, but I cannot find a way to disable the design view. Basically, I am looking for a way to disable the design view option when a user right clicks on a form. I understand that I can disable the...

I have two fields in my Master Table... User ID Completed By Both of these fields are formatted as Memo and contain names. I am trying to structure a query that will give me a count where the User ID field and the Completed By field contain the same name. (User Id = Completed By) Any help...

I am looking to duplicate the "Record x of y" label that appears in the standard Navigation toolbar? I am well aware that there are other threads relating to this issue, but I have not been able to get any of them to work. The code that I found (below) seemed to be the most logical, but I am...

I have a required field that if left blank, I would like a message box to appear that informs the user that the field is required. The code (that I have posted below) works, but not with my particular field which happens to be a combo box. Is there a way to make this message box appear when...

I have created a form with start and end date parameters with the following code (see below)....(Taken from an Allen Browne article "Limiting a Report To a Date Range" in a previous post) The function operates as it should, but I was wondering if there was a way to tweak it so it would... 1...

I have set up a parameter query that prompts for a Begin Date and End Date. This query is linked to a report. I would like the dates selected to appear in the report, but I have been having some problems. I have read that you can set the parameter directly from the report, which I have tried by...

I have designed a form that includes a large text box (in memo format) that can accept a large amount of info. Users often copy/paste large text files/email into it. The size limitation is not an issue on the form, because the user can use the scroll bar to get from top to bottom and read all of...

I have an option button set up called "complete". When users select this option, I would like the current date and time to appear in a box below. Please help with the code. Thanks

I have two check boxes in my form (named as below). In Progress and Completed I would like the user to check one, but I do not want them to be able to have both checked at the same time. I would like the check mark in the In Progress box to disappear when Completed is selected (and vice...