Search results

Would you be able to provide my with an example of how to implement this fuction for my example?

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...

Do you have an example of how this API would be used in access?

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

Here is the test code that works.. Thanks for the help On Error GoTo NoServer DoCmd.OpenQuery ("qry_vendor_Lookup") NoServer: If Err.Number = 3078 Then MsgBox "No Server Available" Resume Next Else MsgBox "This error happened: " & Err.Number End If

Ill try the code.. Thanks for the help

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...

Dim rst As object

try Dim rst As ADODB.object

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

thanks for the help Thanks for the help!! Code works great for pulling the groupings. Ill just have to figure out how to handle the spliting...

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...

Here is the output code I am using DoCmd.OutputTo acOutputForm, "frmsubClients", acFormatXLS, "Test.xls", 0 The problem lies in the subforms recordsource. My subform on the main search form updates as the user selects new criteria, but when I export to excel it only exports the records source...

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...

thanks for the Help. Works great

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...