Search results for query: *

Hi helpful people, I have been trying to do research on my own, but it is not helping. What I want to do: I have 2 tables with multiple records per person. For every record in table 1, I want to know what the previous date from table 2 is and also what the next date in table 2 is. I have...

Hi, I have an access report which I created from an access form. I did a Save as on the form to create a report. Without making any changes to the report, when I open it, I get a parameter popup asking for a field called txtPhoneHome (although the name probably doesn't matter, but it may be a...

I have a form that uses a header and detail section. It is pretty big and sometimes needs to shrink to fit in the area. Strangely enough it moves the top of the detail section out of view instead of shrinking from the bottom. How can I get this to stop? I am using Access XP.

I am using Access XP. I have a fairly complex application. I am using normal, non modal forms. Sometimes when a form opens, it is opening behind the active form. The following code is used to launch a form Note that my forms are Popup=No, Modal=No DoCmd.OpenForm "FormName", acNormal, , "ID...

I would like to create a listing of all open forms in Access in my own commandbar. I saw thread707-1157070, but it doesn't seem to work for me. I am trying to add control 830 which should list the open windows, but it will not let me add it. I also wrote some code that adds all of the open...

I have an application in many locations. All people have the same front end on their computers and their front ends connect to backends on a mapped lan drive that is the same so everyone can get at the data that is only available for their location. We have an issue where the people in one...

I added some checkboxes to my excel spreadsheet. I set their backcolor to transparent. Now when I click on them they sometimes get a white border which looks really bad. Sometimes they get the border and sometimes they do not. Does anyone know how to fix this issue? Is it just a property of...

I am setting up an Excel workbook that launches access databases and then closes them. I use the DBEngine because some of these databases have security around them. I have found that using the OpenDatabase method in DAO does not do what I want it to do. It also opens up Access sessions in the...

I am using GetVersionInfoEx to figure out which operating system is being used. Unfortunately I only have VB6, so it has constants up to Win NT. I am trying to search the microsoft and msdn websites for the new information to get at Windows 2000 and Windows XP, but they keep crashing on me (the...

I would like to run a query in the background so that the users don't even notice. My query will take almost a minute. I want the main form to pop up and allow the person do do certain things while this is running. I have no problem letting the user know that he cannot do other things until the...

I would like to hide a control when it loses focus. I programmed Private Sub lstMenu1_LostFocus() lstMenu1.Visible = False End Sub Unfortunately, on Lost Focus, that control still has the focus, and will not make it visible until it has lost focus. Is there any way to find out which...

Does anyone have a link to a place with really good looking forms? I have an entire application created, but the look of my forms is lacking creativity. I am also running into a problem where I have too many buttons on a form. I think that a form menu would be best, but then I will have to...

I know that I can open a form in acDialog mode and it will stop the code until the current form is hidden or closed. I have a large form that takes a long time to load, so I want it to always be open. Unfortunately, I need to unhide it and have the code stop. I am having a hard time with this...

I have never run into an error where OldValue is not populated for a form, but now I am. I have a form that is based upon a query grabbing fields from 2 tables which are inner joined. Unfortunately, about half of the fields do not have an OldValue but they do have a Value. So I was trying to...

I have a query in a database which I export to excel using the Docmd.Outputto function in VBA. This query has various data types in it. Unfortunately the resulting spreadsheet always formats the number values as dates instead of as numbers. To top it off, I set the formatting in the query...

There is a small caps font in Word which will make your first letter a larger cap then the rest of your upper cap text. Is there any way to get this font in Excel? Seems that if they put a feature in Word, then it should also be in Excel.

I have some subforms on a form, I would like to make the form larger when there is more data in it, and keep it a standard size when there is no data in it. I know the CanGrow and CanShrink help with this when printing, but is there any way to figure out how long the form would be and change the...

I have an XLA with custom VBA functions in it. All of my users have the addin checked from their addin manager. I have put formulas in cells in another workbook to call my custom functions. They work fine when I create the workbook, but when other people open the workbook, there is a #name...

I have been following the directions for setting Access properties via code from faq181-1172. Unfortunately I cannot get the setting for the display form to change. It tried using ChangeProperty &quot;StartupShowForm&quot;, dbText, &quot;<Form Name>&quot;, with the ChangeProperty code from the...

I have a textbox on a form which is bound to a memo field. I am having some problems when there is a lot of text in the text box. If there is very little text, you can add as much text as you would like and everything works fine. If you have over 2000 characters already in the field, you...