Search results

Ok, any clue for doing that? Covar is always 5 characters! Cheers Bob

Sorry Mate, Here's some examples all the values have points not decimals: Currency Value Covar AUD -1111.354 0.00961 GBP 100000000000.13 0.03165 EUR -0.001165 0.57686 USD 1.166577 -0.11355 Cheers:) Bob

Hi all, I have serveral files that are stored daily in a directory with a filename that is always constant and a variable suffix that is the date. Well I am trying to import the file into a table in Access but I have encountered some difficulties, before that here is the code: Sub GetRate() Dim...

Hi to start with this is an Access forum, enough said! I think this might be a clue: Sub CreateNewWorkbookForeverysheet() Dim i As Integer Dim strSheetname As String Dim strPath As String Dim FileName As String For i = 2 To Sheets.Count Sheets(i).Activate strSheetname =...

Hi, Set up some macros in access that does all the uppdating then use: Sub XLUpdate() Dim B As Object Set B = CreateObject("Access.Application") B.Visible = False B.OpenCurrentDatabase ("Path of database") B.DoCmd.RunMacro "Macro name" End Sub Bob

As Namliam states a transferspreadsheet macro would do the trick. Function Macro1() DoCmd.TransferSpreadsheet acExport, 8, "[Customer]", "C:/MyDocuments/Weekly Report.xls", True, "" End Function There is another way from excel to access using ADODB another simple way in excel as well...

Hi all, Have a tough one for you all. I need to find the minimum value across a number of columns. But I don really know how to do this. I have checked the Dmin function but I cannot get this to work. I basically have a database where an entry is sorted by number, date anc accumulated value. The...

Never mind found a solution: [Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null Bob:D

Wow, that is a very good explanation! I have however a little problem with this. It is no problem setting up a form that is linked to the query and thereafter the report. But how can I make the query choose all the records if nothing is choosen (ie unit is blank)?:confused: Bob

Aha, is it that easy? :rolleyes: Will give that a whirl! Cheers Bob

Well what I am having difficulties with is how to actually perform the linkage of the form (where the user can select the unit) to the query that dispalys the report...so basically from scratch I guess... Bob

Hi, I am at a loss trying to suss out how to do this. What I am trying to do is: I have a report that shows a report for 5 units. Now I want the users to be able to choose which unit they want the report to display. The report is based on a pretty simple select query. I have been toying with the...

:eek: Yeah I guess I will rethink my quick fix, adding the [ ] brackets surely did the thing!! Thank you!! BOB

Of course!! I never thought of that :rolleyes:....... Cheers Bob

Hi all, I am trying to access a query which I have done before, but I have come into some trouble. The previous owner of the database had some naming conventions for the queries that is causing me some headaches. Basically I am trying to access the following query Daily information -...

Hi all, I am racking my brain trying to solve this problem that I am having. I have a report that needs to be populated with 30 working days from a start date. I have tried using this bit of code in a query but it does not work, ie it does not identify Saturdays and Sundays accordingly. can...

Thanks NZ works like a charm :D Cheers Bob

Thanks, however I have null values, how do I get around that? Bob

Hi all, I am a noobie to access and access programming and I have a bit of a conundrum :confused: that I cannot solve. I have a database with column headings date, unit and then I have 49 columns from Day one to day 49 with values. What I want to do is "simply" to get the total sum accross...

Hi all, I have a question that I hope someone may be able to answer. I have some 500 text files with the same data apperance (structure). I would like to put these text files into a database but without the manual transferring of the 500:eek: text files i.e. using VBA instead. Is this...