Search results

I am trying to convert an Excel Macro to apply to a spreadsheet after it's been created and populated from Access. However, my experience with Excel code is limited and I find lines like - .Application.HorizontalAlignment = -4108 'xlCenter come up as 'Object does not support this property or...

Thanks Bat17 I'll give that a try... Dave E

Can you explain the method for doing that? Dave

I've used a routine that I found here to export data from an Access table into a formatted Excel Spreadsheet. But a few problems have cropped up... The routine is supposed to create a table from the sql query and then export the data to a buffer spreadsheet, strFile, and then copy it across to...

Thanks IgorB, I'll have a look at the Shell function. I already use the Browse to file function (from this site years ago) but was unable to find any way to open the file from the Browser window directly. (despite searching the site). Thanks again. Dave Eyley

I have searched this topic but can't find exactly what I'm looking for so I hope someone help. I have a directory full of doc files which are constantly being updated. I would want to be able to browse the directory from Access and click on the relevant file to open it directly. So there's no...

I've looked at the form and it appears that there are no linking fields between the main and sub form since the main form holds only the Customer details and the subform holds the parts details. I don't understand the logic behind the subform operation. I would re-think the design... Dave Eyley

Only if you use the '&' sign to concatenate the staement. If you leave it out you don't get the problem...At least, I've never had the problem doing it this way. Dave Eyley

First off, I wouldn't have your tables designed like that... Have a table with the Salesmens names and a unique ID (Primary key). Then have the second table with date, SalesmanID, Calls etc... Link the 2 tables using the SalesmanID. On the form have a date input textbox, combo for the names...

What links the two forms? There should be a common fieldname to both main and subform listed in the properties or in the main forms code... Dave Eyley

On one form? Mmm... Well, on the form you would have your input fields and a button to press to start a bit of code to save the data to the item list table. Then requery a subform, also on the form, to add the log items. Or, have the log details in a pop-up second form. The trouble is the...

=DLookUp("[Name]","tbl_GP_Details","[GPNumber] =[Forms]![frmPatient_Dets]![GPNumber]") It always wordks for me regardless of the link being text or number. As long as the relational link is unique, of course. HTH Dave Eyley

Thanks Bat17 and Neileg, Both of your suggestions worked fine. I can move on now... Thanks again Dave Eyley

Hi neileg, The query is made up from 2 tables - property and space linked by a 1 to many. In the query I have a selection of required fields together with the fields 'Area' and 'SpaceUse'. 'SpaceUse' is the criterion field and 'Area' is the Sum. If I run the query with a single value criterion...

I tried unchecking the field but for the <>9 criteria it still shows the undesired result. I am currently reviewing my strategy. I saw somewhere that's it's possible to subtract the contents of one table from another, so, if I produce a table of the results using the criteria (9) which works and...

Thanks Fofa, I understand. Perhaps I'll break the query up and try again... Dave Eyley

I have 2 queries with the same source tables, fields and relationships. The only difference between the two queries is that the criteria for one of the fields is - =9, in one and, <>9, in the other. The problem is that in the query with the criteria is =9 the results show the GroupBy totals...

Have you thought about using the 'Tabbed Control' option. This allows several subforms to be available on one main form without the need for multiple buttons. Each tabbed control can contain several subforms, if necessary. See the Help info. HTH Dave Eyley

Could you not use - x=x-x for the Me!Check1 box, then it would subtract itself and always end up with zero? Dave Eyley

I have a form that has a graphical representation of days and hours. The user can see, at a glance when a selected meeting room is occupied by the different colours in the day/hours bar which is made up of 47 blocks of 15 minutes from 0700 to 1900. In the form I transfer the info to the blocks...