Search results for query: *

Hi, I have a code in a module that with open a password protected sharefolder which will prompt a popup. Windows Security Enter Network Credentials The code work fine. 'connect to password protected sharefolder Shell "C:\WINDOWS\explorer.exe """ & strPath & "", vbHide This will not put the...

Hi, I'm not going to use the API as Access Runtime File Menu Print Dialog is controlled by Windows. So, API just don't cut it. Users will be running Access Runtime to print from Access Print Menu once the Report is viewed mode. Meaning, users click on the Report in view mode than click on the...

Does anyone knows about the incompatibly? If the first FrontEnd 2003 version link to a BackEnd 2000 version. The FrontEnd 2000 Format is unable to Connect or Link the Tables. If the first FrontEnd 2000 version link to a BackEnd 2000 version. No problems, but FrontEnd 2003 version cannot...

I have a table for a percentage in Tax. Data Type = Number Field Size = Single Another table with Data Type set to Currency. Field = Amount. So I have a report to calculate the Tax. txtTax = 0.05 txtAmount = 16998650 Text1 = txtAmount * txtTax Result of Text1: $16,998,650.51 We have a...

Hi, I want to create a complex INSERT/APPEND action query SQL String. Table Name - Company Field Names - CompanyID CompanyName Building Table Name - TblOldBackup Field Names - CompanyID CompanyName Building Conditions: If records does not exist – INSERT/APPEND into tblOldBackup If...

I have a ADO code that work very well without issues. But when I tried to convert it to DAO, it does not work. Here is the code sample. Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSQL As String strSQL = "CREATE LOGIN test WITH PASSWORD = xxx;" Set db = CurrentDb Set qdf =...

Access 2000 MDB with SQL Server Express 2005. I have upsized my Access database into SSE2005. I had search the net and they say SQL Server needs Primary Keys. Not much details were given and why. I have a Function to delete/create new link tables in Access which is connected to SSE2005. But...

Windows 7 and Access 2010 running in 64-bit. (not WOW64) The dialog did not appear but works in XP/Vista 32-bit and Access 2007 to 2000 32-bit. Note that PtrSafe is included for 64-bit version compatibility and there is no error message. The return value of the API is False which should not be...

Using Access 2000 with SQL Server 2005 Express. I can create a routine to add/drop users and add/drop logins with store procedures. However, I could never find a way to allow users permissions with db_dataread and db_datawrite with a database. I could not google up any search on these or...

I know how to connect to SQL Server. But how do you add user or change the user password in the SQL Server from Microsoft Access? Does anyone have a link or sample codes?

Here's the code. Public Function DeleteLinkTables() Dim oCat As New ADOX.Catalog Dim oTable As New ADOX.Table Dim sConnString As String Set oCat = New ADOX.Catalog oCat.ActiveConnection = CurrentProject.Connection ' Create a new Table object Set oTable = New ADOX.Table For Each oTable In...

I have a problem with my query that is picking out a record not in the criteria. Or it's a bug in Access? Here's the SQL SELECT Inventory.CURBAL, Inventory.[UNIT PRICE], PO.PONUM, POLINE.PONUM, POLINE.STOCKID, PO.STATUS, POLINE.QTY FROM (PO INNER JOIN POLINE ON PO.PONUM = POLINE.PONUM) INNER...

Have anyone encounter this before? Access 2007 SP1 (don't think SP2 will solve the problem) The adp does not have any code at all, it is just a blank adp without forms, reports etc. just the tables from the server. Here the problem. 1. If I create a adp in 2000 format, I can't create a ade...

Access Version 2000. Is there a problem with FindFirst with RecordSetClone? Does anyone knows a link? Below is a sample code. Private Sub Command0_Click() Dim rs As DAO.Recordset Set rs = Me.RecordSetClone With rs .FindFirst "CompanyID = " & """Chubb""" 'error Chubb-SP If Not .EOF Then...

This is the link to hide menus in the office button. http://msdn.microsoft.com/en-us/library/bb258192.aspx I had use it to create to hide the ribbon and other things but I'm unable to hide the Developer menu in the office button. Does anyone have a clue to hide it? <customUI...

I have users inputing into two textboxes “StartDate” and “EndDate”. I need the function to return base on the textbox input. For example, “01-Jul-08” in the “StartDate” textbox “31-Jul-08” in the “EndDate” textbox The return results when the user clicks the button “01-Jun-08” for “StartDate”...

Hi, If anyone could help me with the correct SQL syntax for Updating a table. Here’s the code. UPDATE Table1 INNER JOIN Table2 ON Table1.ItemNo = Table2.ItemNo SET Table1.QtyBal = (subquery1 – subquery2) The two subqueries are Select Sum([Qty]) From Table2 Where IssueDate Between...

Hi, First, I do not have any connection issue with ODBC connection the SQL Server. I connects fine when it is on the same network. TCPIP enabled and tried Named Pipes, still failed. But if the client is on another network, it can't detect the SQL Server. I am using MS Access to connect to the...

This is a sample of a Table called ‘StockItem’ ItemNum UnitPrice SupplyDate 0001 5.00 12-Dec-2007 0001 12.00 10-Jul-2007 0002 7.00 12-Dec-2007 0003 2.00 12-Dec-2007 0004 3.00 12-Dec-2007 0004 5.00 10-Jul-2007 I need to retrieve the rows of ItemNum base on the last ‘SupplyDate’. I...

Hi, I have search this site but nothing comes close to what I needed. Below is the closest code I found. Private Sub setTableDescription(strSourceFile As String, strTableName As String, strDescription As String) Dim ws As New DAO.DBEngine Dim db As DAO.Database Dim tbl As...