Search results

Hello, I am looking to build something to map ODBC connections on a few computers. I found this: Option Compare Database Option Explicit 'Const ODBC_ADD_SYS_DSN = 1 'Add a user data source Const ODBC_CONFIG_SYS_DSN = 2 'Configure (edit) datasource Const...

Hello, I am in the process of ordering some software to enable us to print reports etc from access to PDF. What i am looking to do is print reports from Excel and combine different excel SS in to one main PDF. I know there is the feature to do this in Excel 2007 however it is buggy when...

Hello, I have a module that references UBOUND. It is snaging on this. Is it possible to use this in Access? If so do i need to reference a reference? Thanks G

Hello, I have 2 tables. Table 1 contains details of accounts that are due for renewal. Table 2 has accounts that have renewed. The only link i have is the customer name. My problem is that i can have 1 record in table 1 and 3 records in table 2. So i start with 100 and finish...

Hello all, I’m not too sure anyone will be able to help but I wanted to see if you had any ideas what I can do. Ok, here goes. I have 2 tables from 2 different systems. Table 1: All the policies that are due to renew. (System_A) Table 2: All the renewed policies. (System_B) The main...

Good morning all, I have a table with loads of dates in and their relative data. Everyday i look at everything yesterday (Date()-1). That always works fine in an Access 2007 query. However on a monday i want to look at between date()-1 and date()-3. I ahve tryed using the below...

Hello, Sorry for the some what ambigous title. What i am trying to do is design a way for users to add data and compare records (with my acess 2007 database) without having Access installed on thier base units. What are my options? Is it possible to build an application in VB that can...

Hello, I am trying to call a file (the name changes daily) using the following code: Sub daily() Dim DO_date As String Dim WD_Date As Integer DO_date = Format(Date, "DDMMYYYY") WD_Date = WeekDay(Date, vbMonday) If WD_Date = "1" Then DO_date = Format(Date - 3, "DDMMYYYY") MsgBox...

Hello, I am trying to add values together in an Acess query. In some circumstances the all cells have data and will add. However where there is no data the result is a #ERROR. Is there a way around this? Thanks

I have a list of values all similar to this 0004895. They need to be changed in to UK currency. Thanks

Hello, I’m stuck with a query. I have a table which has a load of user details and their payments. I want to view any payments made 4 working days after the account opening. I can do 4 days np with [date]+4. I have used the working days function to show a value for the day then set up...

Hello programmers, I have the below section of code that opens folders. I now want to do the reverse. Is it possible? Thanks in advance. Call shell("explorer.exe " & str_folder,vbNormalFocus)

Hello, I currently have this bit of code For Each ObjFile In objFolder.Files, which is looking at each file with in a specfic folder. What im now looking to do is have it look at every file within a folder with in an other folder or directory. Can anyone pont me in the right direction...

Hello, Has anyone come across this problem before? I have recieved a .CSV file via SFTP (i have tryed importing in both ASCII & Binary mode) it opens in excel fine however when i try to import it to my database, access cant interpret either the carriage return or line feed. It trys to...

Hello, Im having a problem with this. It keeps failing when the varible looks at an empty cell in the record source. What im trying to achieve is i have a method of attaching a file to a data item then i want that path to rename ready for sending. But i cant seem to make it work...

Hel;lo i am using this: DoCmd.SetWarnings False Workbooks.Open FileName:="R:\do.txt", Origin:=xlWindows ChDir "C:\Documents and Settings\Mccan1t\Desktop" ActiveWorkbook.SaveAs FileName:="C:\Documents and Settings\Mccan1t\Desktop\DO.TXT", FileFormat:=xlText, CreateBackup:=False...

Hello, I have hit a mental wall with this problem. I have a folder full of files and on a daily basis I need to check the file names. If they are incorrect I need to move them. I have written a little bit of code to do this however it doesnt work as required. The files that should come...

Can some look at this and help me figure out where im going wrong. It will work if i relink the text specification. But i can not do this every day. Thanks Option Compare Database Option Explicit Const strpath = "path - not my documents" Function Transfer_external_data() On Error GoTo...

Hello, Has any one ever worked with pushing and retrieving files from an SFTP site? Thanks

Hello, I have been atempting to minipulate this bit of code to allow me to import around 300 files at onc in to a table. All the files have the same structure. Does anyone have the solution im looking for? Private Sub cmdImport_Click() On Error GoTo ErrHandler Dim oFSystem As Object...