Search results

I have a table that has 2 colums. Room_Number Items 1 Chair 2 Chair 2 Desk 3 Table 4 Computer 4 Radio 4 Book 4 Chair...

I have a table that includes a client account number, revenue, and a Date in the format YYYYMM. I would like to create a query that sums the revenue for a client where the date is six months prior to today. Thanks in advance

I have a table that holds the names of locations and a count for each location. example below Location Count INR 100 INR 16 MTU 245 MTU 123 INR 300 RVO 1234 TC 45 TC 188 The table is always changing and I need to create a query in code that sums the count, grouping for each location. These...

I have an access form that allows a user to browse to a specific file on the network. Currently im able to return the path of the file, but I would like to know on which server this file is located. Is their a function to return the server name of a file stored on the network? Thanks in advance

I have a current database application that is used by our sales team. The information used by the database is pulled from our SQL Server. The problem I am running into is most of our sales staff lack the access to the data source when in the field, but still requires the use of the program. I...

I have a form that displays customer account information. The form is connected to two tables. each customer has their own account number that i use to lookup their information. right now i have to click on the account number field and click find to pull up the record. I have built a popup form...

How do you create a query in code. Actually creating a query that appears under the query section of access. Is this possible? Thank you

I have a comment that I pulled with a dlookup from a table. Example below Interface request received and filed (nk-11/14/2006) Test file sent to vendor. (nk-11/15/2006). I want to seperate the data based on date. Example below 11/14/2006 Interface request received and filed 11/15/2006 Test...

I have a form that allows users to specify the information they want to be displayed on a subform. I have used the below code (simpilified for example purposes) to create the SQL string and sent it to the subform for display. I would like to have an export to excel button to export the...

I would like to create a program within access that is linked to a specific folder on my C:\ drive and waits for a file to appear within the folder. Once the file appears, i would like access to process the file and return the output back to the folder. Is there a way to do this? example...

I have a table that includes client account information. I want to create a query that will select all account numbers where the last updated date is less than or equal to a number specified by the user. Table (ClientRequests) AccountNumber LastUpdated 76869...

I would like to create a new folder with a specific name. example I have a k: drive where i want the new folder created I want to name the new folder under the k: drive. Im sure this is very easy to do, but i can't seem to find an example in the forum. thanks in advance

Is there a way to send an email using outlook, have that email filtered into a specific folder, and then have an access program extract that email. The situation is that I have sales reps in the field that would like updates on projects that are stored in an access program I designed. The...

im responding to the code you submitted to draw lines on a form. I am trying to change it a bit to only draw dots. I have x and y cordinates that I want to draw on the MS form kinda like a scatter graph. So I want to pass values from a table into the function LineX. Then have the function create...

I have a table that contains X and Y cordinates. Is there a way to take those values and graph them on a 100 by 100 graph? any suggestions.

I have a txt file that includes X and Y variables like below, with a comma seperating the x from the y. 1.5,2 1.9,30.25 100.00,5.23 4.16,12.3 10.23,14.5 .. .... ..... up to an unspecified number how can I import the txt file data and place that data into a table. A GPS device creates the txt...

im using this code to generate a random number. But everytime I close access and reopen the form the random number generated is always the same Private Sub Form_Load() Dim random As Double Dim random2 As Double random2 = Int((100 - 1 + 1) * Rnd + 1) random = 0.1 random = Int((30 - 1 + 1) * Rnd...

I have a form that outputs the total number of calls an employee takes on a day to day basis. There are 5 employees, and there is a textbox for each one. I would like to create a command button to take those values from the textboxes and place then into a text file on my hard drive. Please...

I am creating a database that allows a user to order products. So far I have the user login functions and a template for a product search page. What my question is, is I am trying to mimic a search page that looks something like amazon.com so that when a user clicks on a category it displays all...

I am creating an order form. On this form, you can choose a supplier from a dropdown menu. There are certain products that can be ordered under that supplier. My question is how can I populate the product dropdown box with the products from the supplier and then be able to select from that...