Search results for query: *

Ok so I am making a DB to manage my Ebay Inventory. One of the tables is EBAYCONDtbl, which keeps the applicable condition options which correspond to a Ebay Category ID. So basically like Mens Shirts have a particular set of possible conditions and Womens shoes would have a different set...

Here is what I'm working with Form = MAINfrm (Single Form) Subform on MAINfrm = MAINsub (Single Form) Subform on MAINsub = INVsub (Continuous Form) Fields on INVsub = ITEMIDbox, ITEMNAMEbox, ITEMSTATUSbox I also have a Rectangle on the form called BGbox Options for ITEMSTATUSbox = Active...

I have a main form with a searchbox. Under that I have a subform. When the user tabs from the searchbox to the subform, the GUI changes and I lose view of the searchbox on the Main form. And I can't tab back to it. Here is the design view. Here is the Main form view showing the contents of...

As the subject says, I have an Access Database being used on my computer... I want to connect to a MySQL database I created on a Godaddy hosted server, of which I am the admin of. I want to query the db to validate subscription status. Access database has a field in a table for the users...

I'm building a database to be used to help monitor a small business (specific industry). I plan to put my database out there for others to use. I also decided to charge a meager fee (like $5 a month) for it's use (obviously to pay me for my time for development and updating it)... but also to...

Here is what I want to do... I want to have minimize and maximize buttons on my form, but I do not want a control box. Also, I do not mean Minimize/Maximize like the controls in the Control Box. I mean in minimized form - the form is very small (limiting view to 1 textbox and the min/max...

Ok, so I'm trying to loop thru a query and pull out the data in the first field of the query. Then concatenate that data into a string to be used in Google Maps. The data represent addresses for stops on a trip. If I use a simple Select Query like "SELECT * FROM STOREtbl" - it works fine...

I'm making a DB to help me with an online business. I want to copy fields from a recordset and be able to paste them into a website to fill in a form. I know I could just alt-tab and copy/paste field by field. I'm an Ebay reseller and I'm creating a DB to organize my inventory at home. So...

I read you can declare a variable and assign it on the same line, but on that forum post... there was confusion as to being able to do it with String data types. 1 guy said, yes...another said no. I can't get it to work... but thought I'd ask if I just have my syntax wrong... any help would be...

I was wondering if there is an easy way to lock out users from accessing tabs. I found code that prevents the user from right-clicking the active tab and choosing "Unhide"... (see below) Application.CommandBars("Worksheet Menu...

I have a workbook that's currently unprotected. The user would click a button and data would be transferred from one sheet to another... this worked fine. But for some reason it quit working. I noticed that the destination sheet was protected... so I deleted all the code that protected or...

As the title explains, I'm wanting to keep my application on top of all other programs on my desktop and I want to hide the Access Window. I can get either working individually, but can't get them to work together. I've attached the file because explaining what I've done to each form would...

Using Office 365 - Excel. I have a form ESTPAYMENTWMAPfrm, on which I have some textboxes with data and a WebBrowser object. WebBrowser object is named MAPBLOCK. All I want to do is when the form opens, I want the WebBrowser object to navigate to a url. Eventually I'll use a cell value, but...

Can someone please tell me why this code works... If Sheets("Sales Datasheet").Cells(i, "C").Value = "672144" Then Sheets("Sales Datasheet").Cells(i, "E").EntireRow.Copy Destination:=Sheets("Office View").Range("A" & Rows.Count).End(xlUp).Offset(1) End If But this one doesn't. If...

I have a Sheet of data with a button on it. When I click in a row to identify the row of information I want to use... and then click a button on the worksheet - a Form opens and I transfer the individual cell values that I want to look at onto the form. Everything works, but when I close the...

New to VBA coding in Excel, I can't seem to figure out how to code this. I want to go thru each row of the "Office View" worksheet. In this table, column C is for License Numbers and column W is for Bonuses (currency). The code I'm using below is resulting in only the Column W Value for the...

Ok, so I'm working in an office with about 60 people. There is a need for a spreadsheet to be used by everyone. Main users will input information. Office admin will verify info and add some info. Then users will use the spreadsheet to fill out a form and print it off. Background on me: I...

Please check my syntax? UPDATE STATUStbl SET FOLLOWUPDATE = #6/9/2015#, STATUSHISTORY = 'Will be at the dock on Monday FOLLOW-UP DATE CHANGED TO 6/9/2015' WHERE STATUSID = 1 Table: STATUStbl Field: FOLLOWUPDATE; date STATUSHISTORY; text (memo) STATUSID; Autonumber (primary...