Search results for query: *

Hello, This is a fairly lengthy post. My apologies. The context for my questions is a form that opens with a listbox full of some 60 room/household area names and a subform where a user can place names selected from the listbox in descending order of selection. Names are added to the subform...

Here I am, closing in on the final scenes of this act in the development of a commercial application. Testing and debugging a form for the wheel of the wheel mouse. Have I been successful in disabling it? The wheel must be disabled to prevent a user from scrolling into a new record. I use a...

This is going to sound strange and so it is. The problem is in Access XP. I have a listbox on a form with the names of various room names for a house. The objective is to have the user double-click any of the room names and that room will be added to a subform that is updated to show the...

Greetings, This is a problem that has been plaguing me for months. Tonight I thought I had it. It worked in AccessXP fine until I compacted the database, then the same old problem. I have a main form with a subform set to Continuous Forms. It is populated by a query but is not related to the...

Greetings, I have installed XP Developer, Office and looks like VB6. I did not opt for Visual SourceSafe (VSS) as I am a single programmer. Now every time I attempt to get into the code for an Access existing program, I get 2 error messages "Visual SourceSafe client is not...

I need to obtain a simple English to Spanish translator, reasonably accurate, that I can manipulate through Access. Cost is a real factor but I'd appreciate hearing of all options. I'd like to hear from any developers who have used either a custom built or 3-party translating program in a...

Greetings, I have been searching for a thread to address but have not thus far been successful. I wish to create a report that when printed will be cut in half (8.5" X 4.5" or 4.25" X 8") to create 2 pages to be bound in a workbook. The report design calls for the first...

My client desires that certain text in the data tables of the application I am building be available to users in Spanish and Russian both in forms and reports. I feel confident about the ability to create additional tables with translated text but am unsure how to handle special keyboard...

I plan to use XP Access Developer to create an application for distribution in the commercial market. Customers who purchase the software may have XP but more likely will have earlier versions. I am aware that there is a conflict if a XP Runtime is installed on a PC with earlier versions of...

In VBA coding, Access97, can I reference a recordset in a 2nd recordset? My current code returns a Run Time Error of 3421: “Data Type Conversion Error” when doing so in a fairly simple set of syntax. Ultimately, if I had my way, a 3rd recordset would be referenced as well. I have two...

Hello, I want to pass 2 variables from two different forms to a common routine. The routine needs to return 4 values to the calling statement. I am unsure what structures can handle this. I would appreciate any advice. Regards, Sorrells

Greetings, Here I am again, treading where I've never trod before. I have looked through a lot of threads but cannot find what I am looking for which is this: I have several tables with common field names. Within a form, and totally outside the realm of form controls, I need to access one...

I am in Access97 and have some essential reports that are opened in Print Preview. I really, really would like to know if the user actually printed the report opposed to just looking at it. I can find no report property that might help me. This is to be an application that could find its way...

Hello, I would like to enable the Page Up/Down and perhaps the Arrow Up/Down to turn pages when a multi-page report opens in Print Preview, 100% zoom. From what I have read, this looks impossible but perhaps someone has succeeded?????? Regards, Sorrells

I have a form with about 10 recordsets. Of them 7 are named rstTemp_1, rstTemp_2 on to rstTemp_7. They are temporary RowSources for listboxes in the form. In using the form, one, two up to all of the listboxes may have data placed in them. I am looking for a method to loop through all the...

In a form in my program, I may need from 1 to 7 listboxes based on the days of the week depending on how many the user has selected in an earlier form. For each listbox, I need to create a temporary table to hold text data that is to be drag-n-dropped from one table to another. I would like to...

I have a listbox that records are added into. The listbox can hold 16 records before it is filled. When a 17th or greater record is added, all the previous records are hidden with only the new record showing. I would like for at the 17th record for it to then: - display the last 8 records...

I've got to be doing something pretty dumb here and hope someone will grade my card to see what is missing. I am using SQL to assign a recordset to a listbox. The code looks like this: Dim Table_Name As String Table_Name = "[Lookup:" & lbl_1.Caption & "]&quot...

This will sound arcane but here goes. Can a form created in Visual Basis be incorporated into Access? My client feels there may be an opportunity to better use a Drag-N-Drop function for specific forms I have created if they were VB forms. I have looked all day in various forums, sites to...

Hello again, I have been searching the forums and it appears that I want to do something that is not often attempted or thought of. I have a single field returned by an SQL query with up to 15 text items. I would like to have these items displayed from left to right and then descending with...