Search results

Is there a way to open an Access table as a record set from within Word VBA. Basically I want to takes 6 variable out of Word and import them into an Access table and I will be looping from page to page. I'm just not sure how to open a record set in Access from Word or if it's even possible. TIA

Hello, Is there a way to delete the first character of every line in a text file? TIA

Hello, Let me start by saying, I know I don't have to open Notepad to edit a text file, but in this case I need to. So I receive a text file from a main frame. The first character of every line is an unrecognizable character, see below. I need to be able to remove this character. The...

Hi, I have a form with a Tab Control on it. I have 3 tabs on the Tab Control and I am trying to SetFocus to a specific Button on each Tab when I click those tabs, but it doesn't work. It's acting like every time I click those tabs it chooses a different focus on that tab. I hope I explained...

Hi All! I have spent hours trying to figure this out. Is there anyway to change the back color of Tab Controls? All that shows is a white backgound. Thanks!

Hello all, I have a table that looks like this: It shows Customer Number, Name, CityState, and the days of the week with Delivery ETAs. Is there a way through code or a query where I can have customers with the same CustNo be on one line instead of the two. See below. Thanks for any help...

Is there a way to allow a user to select a font type and/or size of a report through a Form before the report is opened? The different reports are various labels and sometimes there is more of less data on them. So if there is more or less data, they can change the font size to fit the label...

I have a macro that uses ImportExportSpreadsheet option, but the file is hardcoded. Is there a way, within the macro, to open a select dialog box to allow me to select a file. I know I can be done with VBA just didn't know if there was a way within the Macro. Thanks

Is there a way of opening a second database using VBA from within the first database? Thanks

I am trying to copy a file from a SharePoint folder to a local folder on the C:\ and I am getting the following error. Here is my code: FileCopy...

Is there a way of increasing the barcode height in a text field on a report without increasing the length? I am just trying to make the lines longer. Thanks

I have a simple database that is only used for printing labels. It pulls in a spreadsheet with three fields. Label Text, Label Barcode & Direction (Up or Down). Then prints out labels with the Barcode on top, the Label Text below and an arrow image to the right, either pointing up or down...

Let me see if I can explain this.....So I have a database that sends out emails as text messages to drivers and allows for attachments, which works fine. Currently all of the code in on the "Send" button, but I am trying to separate the code so when you click the Attachment check box you get...

I have a database that multiple people utilize. It is used to send text messages to drivers though outlook. The problem I am running into is that we use multiple versions of outlook and the Reference is different. One uses "Microsoft Outlook 15.0 Object Library" and the other uses "Microsoft...

Hello everyone, So I have a query that is based off of a ComboBox, which has 6 choices. It has the name of 5 different Shuttle Yards and the last choice is "All Yards". Below is the code in my query, but when I run it I get the following error. "The expression is typed incorrectly, or it is...

Hello, I am trying to setup a query that looks at a ComboBox named "Location". If "All" is selected in the ComboBox, I want everything displayed in the query, but if a certain location is selected, then the query only displays that locations information. That part works fine. It's that "All"...

Hello everyone. I am new to Recordsets and Looping. I will try to explain this as best as I can. I have a table with two columns, Phone Numbers and Drivers Times: CellExt DriverTime 3335551234@vtext.com Louden 5:30 3335551234@vtext.com Garner 2:00 3335551234@vtext.com Wells 5:00...

I have a txt box on a form that the user types a message into. But there needs to be a maximum of 150 characters in the text box. I am trying to create another text box that shows how many characters are left as the user types in the message. Text36 is the box where I want to show the...

Is there a way of linking an Unbound Text Box to a field in a table? The Form already has a different Control Source and the Table only has one Field with one value in it, but that value can change. I just want to pull that value into the Unbound Text Box when the Form loads, but can't seem to...

Hello all, Is there a way of removing the top menu bar of a popup form? I know I could set the border to none, but I still want the thin border all around the form, just not the top title bar. Thank you