Microsoft Access / VBA Forum

Hi everyone, I have a form with a combo box on it. When you select a value (a PO#) from the combo box, the bound field is the indexID of the selected PO. On the same form, I have a text box that I'd like to feed from a query I've built. The query does some math and comes up with a number (qty allocated) for the selected PO. There are two...

Hi everyone, I was hoping somebody could assist me in this issue. I am quite a newbie to ODBC connections and was struggling to search for related topics. Here is my situation: I have a Access 2000 .mdb file which has several linked tables to a ODBC data source, namely an Oracle back-end. I have already setup the connctions to these...

Anyone know a way to make all access to a linked table, in another Access MDB, read only? I really don't want all the hassle of implementing full access security. I can't do this at the server file system because in some front ends the user needs update access. I want to give users access to the data for reporting with their own...

I have a linked Sub Form in Access 2007. It is designed to only show one Record. (Always 1). How do I Hide / Remove the Record Navigation bar for the subform? Thanks Brad

I've got a bound report with a query as the record source. I'm adding a total to the footer and have inserted a text box to display it. I'm attempting to set the control source of the text box to a different sum aggregate query using the expression builder. When I select the query and it's single field, single row field it inserts the...

Is there a way to have an input box "Pop-up" on a form to capture information? I do not want to create another form for this. I was thinking something similar to queries when you have the criteria = and it auto generates a textbox with "Enter Date" as the caption. Thank you!

This is an example of code that uses a multi-select ListBox control. This is an area that seems to cause confusion and difficulty for many of our members. Dim valSelect As Variant Dim strValue As String ' just used for the demonstration For Each valSelect In Me.listboxName.ItemsSelected strValue = strValue & "'" &...

The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art and the report Picture properties would fill the bill, but not so much. An image added like that is a background to the report, so text in the report...

I don’t know VBA but have been using Access for awhile using tables, queries, forms and macros. I am trying to automate importing a number of Excel 2007 spreadsheets into an Access 2007 table. The import will be done each month, but the number of spreadhseets could be different. The spreadsheets will all be saved to the same folder. I need to...

I have a combo box that I would like to be able add items to in the back end VB, but With Forms!search!search .Visible = True .additem "Application" End With gives me a runtime error 438 on the add item line. Can anyone point me in the right direction please?

Hi: I imagine there are hundreds of responses to this question, but i cant find any on the site using a search. How do you change the background color of buttons? I know there must be an easy way, but the properties just doesn't have anything to do it. Quick hints appreciated..

Many Access Users fail to realize that it has a built-in Progress Meter that can display the relative completion percentage of various processes. It is fairly limited, but nonetheless, does provide visual feedback indicating the percent completion of a certain task. The Meter itself, when activated, rests on the left hand corner of the Status Bar...

How would I do this ... I want to set the Windows Scheduler to run the ..bat file which will open an access database at like 2 in the AM. What code do I need in the .bat file.

rst.eof = true and rst.bof = true or rst.movelast rst.recordcount = 0 ?

Is there a way to check user input for illegal characters? For example, a user enters something into a text box and clicks OK. At that point I'd like to run code such as this: illegal = Array(\, /, :, *, ?, ", <, >, |) If Me.TextBox Contains illegal Then MsgBox "You entered illegal characters. Please try again." Me.TextBox = Null

I have a listbox which show customer Names on the 1st column and PO numbers on the 2nd column. When user select the customer and press the OK button, it will access to the PO form. Problem here is the list will grow longer and longer and I need to scroll up and down to look for the correct PO. I would like to create a textbox below the...

I'm trying to import a tab delimited text file. The text file does not have column heading. I can give it column heading if needed. How do I change the defult comma delimited to tab? If I need a specification file, what does one look like or how can I create a specification file. I have over 400 tables I need to import into the...

Dear All, I have code that selects - find and select - 1 item in a large listbox. This works Ok but most of the time the selected item isn't visible without scrolling down manualy. Is this possible by code? Filip

I feel embarassed asking such a simple question --- Year(Date()) returns 2004; I want only the last two digits. Format(Year(Date()),"yy") returns 05. How do I get 04? Thanks! Mark

I have read everything I can find on the internet, BUT it doesn't help! I'm using Windows XP and Access 2003. The following code does increment the listindex as wanted but then after coming back from Private Sub Combo AfterUpdate() zeros it out. You need line one to stop the 7777 error. In addition, line three fires the Private Sub Combo...

Recently, there have been several questions and much confusion concerning the Topic of Hyperlinks. Specifically, Users wanted to know how to retrieve a File Name from a FileDialog Box, copy the Name to a Bound Text Box on a Form, and save the Hyperlink to the underlying Table. The code demos below will do just that: retrieve the Absolute Path of...

I have a report in Access 2003. If I set the can shrink property on the textboxes they are invisible when they are empty, which is what I want. But it does not hide the associated label connected to it. Is that possible to do, either with vba or visual basic 6? Thanks

Can I program a label with a carriage return to put the 2nd part of the label on a new line. The only way I can see of doing this is to convert the label to a text box, then use chr$(13). dixie

I have a couple of Global variables called ExportStartDate and ExportEndDate, respectively. When the user wants to export data to Excel I allow them to specify the date range, but they can also Cancel the action. If they hit Cancel, I want to set these dates to Null and then test for the Null value. If NULL then I bypass the...

Last Tip, we demonstrated the technique for retrieving data from a DAO Recordset, and placing it into a 2-dimensional Array using the GetRows() Method. This week, we will cover the same exact Method (GetRows()), but only as it applies to an ADO Recordset. Although there are similarities in the 2 methodologies, the ADO Method offers 2 more Optional...