Search results

All..I'm trying to export a query with date: Private Sub cmdExport Dim qryname as String Dim theFilepath as String qryname= "qryExport" theFilepath = "C:\Users\" & Environ("UserName") & "\Desktop\" theFilePath = theFilePath & qryname & "_" & Format(Date, "yyyy-mm-dd") & ".xls" Docmd.OutputTo...

All, using access 2016...I have a report based on a query I need users to export to a folder on the desktop.The button is on the form. It runs but just places the field names in the columns with no data. Also On the left side there's the numbers 123 like its tring to group something. Here is...

All, using access 2016. I have one table with custid, state and order id.. some have the same cust id and state. I want only the records that have the same custid and same state. I keep getting everything. My query is the following select customerid, count(*)as st_count from...

GM Using Access 2010. I am using the following code to audit a form in my database which works fine: Sub AuditChanges(IDField As String, UserAction As String) On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim...

All, does anyone have a calculation for getting the monthly business day based on the date logged in another field by a user? Ex. completed date field is 1/12/2016 business day of the month is 8. Thanks

All, I am trying to make an IIF statement with three possible outcomes and not working: IIf([status]="Active" and [Type]= “Cost”,[rate1]-[rate2]+[ rate4],IIf([status]="InActive",[ rate1]+[rate3],[ rate2]+[rate3])) AS newRate It tells me i'm missing parathesis or wrong argument. I keep...

All, using Access 2010. I am trying to push a file into production. I have a split database and 50 users. It is giving me an error when trying to make an accde: Microsoft Access was unable to create the .accde Help shows: This error is usually associated with compiling a large database into...

All, using access 2010, I'm trying to use len in an IIF statement: Type: IIf(Len([qryMaster].[PAYROLL])<3,[”Active”],["CLIENT”]) When I run the query; it puts brackets around "Active" and "Client" and it doesn't return any values. What am I doing wrong please.

All, using 2010. I am using a barcode type and cannot get it to print where the barcode scanner will scan. I did however test it in word and it accepts it with a parenthesis () around the number. I tried to put () around the control but I am having a senior moment and can't remember how you...

All, using access 2010. I was recently asked to lockdown one of the users database outside my dept. I split the database, created an accde and put a copy on all user desktop. I put the backend on a shared server. Now I find the users are used to running queries using the F11 function. I...

All, using 2010. My build in switchboard used to open in the center. all of a sudden; it is opening full screen. I tried playing with the auto center controls to no avail. I know it's something simple and this is driving me crazy. Please help

All, I am using access 2010. I am using code for Audit Changes as follows: Sub AuditChanges(IDField As String, UserAction As String) On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim datTimeCheck As Date Dim...

using access 2010; Can and How do I upload fonts for a barcode scanner program. Thanks

All, using 2010. I want to create or find a gradient background for use in my access database. I am having no luck. I can't find any effect tools in Access. Anyone have any suggestions?

All, using Access 2010. Looking at the table below, I need to query so that the results would identify only the CUST ID with different Rates in the same state. The query results in this case would be 1300 and 1300A. I tried to do a group and count but I get everything. Any suggestions...

All, I am using 2010 Access I have a query that returns what I need. But now I want to exclude records that are in another table. How do I exclude all records that are in another table. My first thought was to use the where clause but I want all the records to be excluded in the table. thanks

Hi All. I am using 2010 access ver. can you change the color of the text in a msgbox. I've searched but have not come across any thread pertaining to this. Example: "MsgBox "DO NOT CONTINUE UNTIL YOU.. I would like the text to be bold and red. Thanks

All; I inherited a database that has two tables that are structured identical; one called tblcurrentdata and the other called tblpriordata. The user wants a report or export query that only shows records that has differences between prior weeks data and the current weeks data. The tables have...

All; I have a question. I have a form based on a table with just sales quotes and dates. I am using the salesquote as a combo box to select cooresponding records in a subform. Private Sub cboSalesquote_AfterUpdate() Me.Filter = "[salesquote]=" & cboSalesquote Me.FilterOn = True End Sub...

All; I have a form and subform with the following names: frmBasic sfrmCustomers I have a unbound txt field called txtCustName on the mainform I want to populate this field from a field on the subform called CustName when the record is selected. I also have an unbound combo box with the cust...