Search results

I was wondering if anyone knew the answer to this... I have a form ("form1") with a list box, I will then click and open another form ("form2") and enter some data. Then go back to form1 and the list box will populate. Question, I wanted to set it so when I come back to form1 that it will...

Hello all, I am having an issue with an input mask not working correctly. I have a text box that has an input mask 0000\-00;0;_ which displays as, for example, ____-__ so a user can put in a number like 1234-56. If I type in a number manually, it works fine. Puts it into the table as 1234-56...

Hi, I was wondering if it was possible to append to an existing record. I have a table that has a memo field. I would like to pull a record and append new information into that memo field and keeping the data that was already there. ==edited== Sorry, I should have said that this will be...

I have a form that users enter in data on. I am running validation on those controls using an "event procedure". I placed the code in the BeforeUpdate of the form. I have a customized menu that if the user clicks "Home", for example, it takes them to the main form (not the form that the data...

I have a form, in which you can select a variety of option of where to output the data. Option 1 is to a spreadsheet, 2 is to an access report, and 3 it just to open a datasheet view. This is all based off of a crosstab query using a querydef (temporary query that gets deleted at the end of...

Hello all, I need some advice and someone to point me in the right direction. I have a table with a field in it that has text and a numeric value. For example, the field could have a combination of the following... 15 Mins or 1.5 Hrs. or 60mins Although most of data in the fields will be...

Hello all, I have a question about adding in code in the error handling. How does the error handling execute the code. For example, in the following code, I want to delete the querydef if there was a problem executing it. I understand that there are a million ways to handle this and this...

I have a crosstab query and I noticed that 1 "Car" item was not being pulled in. I know that this item does not have any of the required items (i.e. the categories are null) but I still want it in the list. I put a left join in thinking that it would select all Cars from the table. I must be...

Is there an easy way of doing alternating colors in the details section of a report. This isn't critical, it would just be nice and if there is an easy way of doing, that would be great! -Stoss

Hello, I have a crosstab query that I populate a report with. In the details section, I have 12 textboxes (which are months). I want to sum up all those boxes for each detail (i.e. each row). I was thinking that having an additional text box with (the following code in that textbox control...

Hello all, I was just wondering how the best way to handle this situation.... I have a combo box that has employee information (i.e. Name) and this is used when creating a new Purchase Order, and shows their name when selecting previous records. The question that I have is what is the best...

Hello all, How do I get specific information from a function that I run from a query? I will pass 2 parameters to the function but I want to get some text in return. I use this function for populating text boxes from other forms but it has the same logic structure so i would like to also use...

I have two reports that are fairly similar. In both I used Me!txtMyCaption = strLocation & "'s " & "Priority Report as of " & Date (same name in both reports) It works fine in one report but not the other. In the one that doesn't work, it prints all the text you see above except the date...

I run a function from "Current" event on form2. This sets up different text boxes with the proper information for that record. On that form I have a drop down menu that changes what would be shown in those text boxes. To clarify, on current form, function sets text boxes. On the same form is...

I am trying to reset a list box...which works in a sense. Dim varItem As Variant With Me.lstPriorities For Each varItem In .ItemsSelected .Selected(varItem) = False Next varItem End With It deselects all the items but then, as part of the error...

Hello all, I am having a bit of a brain freeze and I need help with this function call. The following code is currently placed in a form. I also need to use the the same code for a report so I wanted to move the code to Module1 where I can call it from either the form or report. The trouble...

Hello All, I am in need of some advice.... I am running a search box that a person can select 1 or more items ("Priorities"). I need to run some complex (not hard just lengthy) custom queries but I don't know the best route to take. As it stands now, I would have to put in a multiple...

I am getting error message 2163...which states... "2163 - The page number you used as an argument for the GoToPage action or method doesn't exist in this form" Page 1 of this main form is the default form that is always up. I am working in another form (search form) in which I call that main...

Just wanted to say what a great website this is and how much it has helped me. I am learning so more and more and I am trying to help others as well!

Hello all, I have a quick combobox question. I am having a brain freeze :( right now and for the life of me can't figure this out. I have a combobox with SupplierID info. When this box is changed to a different supplier, a subform changes to list the items for that Supplier. Basically, what...