Search results for query: *

I am trying to setup a report whereby the user can select the fields they wish to see from the previous form. Does anyone know how I get Access reports to configure itself on execution. Without creating a report for ever conbination. e.g. There are 5 fields displayed on the form each one has a...

Thanks for your help. I couldn't see the forest for trees. Cheers Stoff

I am trying to create an Edifact formatted payment using Access. Does anyone know how I can easily convert an amount from using a decimal point to using a comma as required is this and many other payment formats e.g. If a user keys in the amount 12304.45 I need to convert this to say 12304,45...

I get a Runtime Error 424. I assume that Access 97 is just too Old. Any other suggestions ??? Cheers Chris

Thanks for that but as I am only a newbie to this I need a bit more info. I have been looking in the Object Browser and the help, and I can't find anything. Could you give me an example of how this is used Cheers Chris

Does anyone know if it possible to import a spreadsheet with a known name that sits within the same file location as the database however this location isn't known. This database will be in multiple file locations and I want the code to be dynamic Cheers Chris

Tom, What a doughnut I am, I couldn't find this event because I was looking at the properties of the whole report and not just the detail section. I will check this out when I head over to work tomorrow night. I spent hours just banging my head against a wall on this. Thanks a lot Cheers...

I am trying to set the visibility property of a field in a report to 'On or off' depending on other information in the report. For example if a member of Staff has a skill set of 'L2 OLB' then make the Sales target field invisible and the Feedback target visible. The code runs on the 'On...

I have a table (TBL1) which list Test scripts in Cycle 1 and the status ie passed or failed. I have run a query (QRY1) to see what has passed and failed in Cycle two I am trying to update (TBL1) with the results from the query (QRY1) When I try to create an Update Query (QRY2) and link the...

Have added Microsoft ActiveX Data Ojects 2.7 Library and Still have the same problem. Here is the whole code as is, with nothing changed. Are you saying that I should change the 'CurrentProject' to Say 'Access97'? Sub ReLinkThem(ByVal myServer As String) Dim cat As ADOX.Catalog Dim tbl As...

Right we seem to be getting somewhere. I followed all your steps. It fell over with a Compile Error, Variale not found. In the Visual Basic window its hightlighted. 'Sub ReLinkThem(ByVal myServer As String)' in yellow and CurrentProject.Connection in dark blue. Not sure if this helps but when...

Ok Guys I have been down the pub and had a couple of beers, and now life is looking a lot better. Yes you guys are right I am working on Access 97 and not excel. One of my Tables is a linked table to an Excel spreadsheet. The problem is when you link an Access table to an Excel spreadsheet, it...

You lot are having a laugh with me. There is no such thing as macro recorder in Access97. Under Tools--> Macros, it only allows me to run a macro not record like it does in Word or Excel. As far as editing the table is concerned I am not sure I no what you mean. I can open a table, look at the...

I must be more stupid than I look. You will have to spoon feed me here guys as I can't get this working. Where is says 'varA(0) = myServer' you want me to change it to read 'varA(0) = \\lmpstmf05\rtp' . It highlights this in red due to the backslashes. Also how do I launch this code, I assume...

Sorry, that sounds all very simple but where do I put this code. All I did was click on file--> Get external Data-->Link Tables--> then located the excel spreadsheet in the file system. Cheers Chris

My Application is used in different locations, by different members of staff. Part of the application uploads data from an excel spreadsheet. The problem arises when different members of staff have set up there Network drives as different drive letter alias's. For example the linked table in...

I followed the same route to export the Report. It only saves it in RTF though. I am running Access 97 and word 97 so maybe thats the reason why it doesn't keep the formatting. Any more ideas anyone please. I have to get this done by the end of the week. I can't believe that two MS products...

My Works PC does not allow me to look at News Groups. How do you set up Access to export to a PDF file then? Cheers Chris

I have just spent ages getting this report format correct. Now that it looks lovely my Boss wants to be able to export this to Word/Email. On doing this I notice that all the formatting is lost. Does anyone know of a trick to keep these formats. Table borders etc. Cheers Chris

Does anyone know how I can kick users out of my database (after sending some sort of message)as there are users all over London and its making updates difficult. Cheers Stoffman