Recent content by jackmac

Thanks for the reply.. I'm still a little confused. In Design View, I've right-clicked on a field and the box that pops up offers me 'Control Source' but not record source.. no joy there I'm afraid. Right click on the form brings nothing.. am I missing something?

Hi all, Hopefully an easy question. I've been asked to look at an Access 2003 table and modify it. It's been a very long time and I've got a little stuck. I have a form on it and I need to know which table the fields are looking at. There are several hundred tables and a few forms so knowing...

Hi Pat, Timberline is another Sage product which I want to get the information away from. That's why I'm trying to use Access. Sage seem to be very restrictive on how they allow information to be extracted - even when using their own ODBC connection! Not a fan of Sage I'm afraid

Hi Pat, Thanks for the reply. It would be much easier if I could link directly from Sage to Filemaker but unfortunately the table I need to see taken into Filemaker (Sales_Ledger) is not visible. If I go from Sage to Access, the information is visible! I was chatting to someone earlier who...

Thanks for the replies. I'll try to summarise what I'm doing. I need to extract data from Sage and get it into Filmemaker - Filemaker good... Sage bad! If I use Access as a 'middleman' I can pull the data from Sage then Filemaker pulls from Access: Sage ---> Access ---> Filemaker The info...

Hi all, I'm building a database which I want to pull information from an ODBC source (Sage 50 2012). I can either Link Tables or Import - both of which bring the data in. Unfortunately when I try to pull from the created Access file I can only see the Imported table I create. Is there a way...

Hi all, Been working on a database for a few weeks and had some awesome help (thanks David!!). I'm nearly there now, just got one thing before I go 'live'. The database has two tables (more but you get the idea). One of the tables has a set of choices (product types such as window handles...

Hi David, That all makes sense, and I agree is the correct way to do things. I think perhaps I was looking at it in a different way. I was thinking that in the next year, if prices rise by say 2%, I could apply a 2% rise across the prices, but the better way to look at it would be that my...

Hi David, I originally went with that method but it proved unworkable after I figured it would mean a percent change would mean a change in every record rather than in one place. I wanted to have a single point of change for the percent - to be honest, I may only change it once a year, if...

OK, found another slight issue... When I change the percentage value then go back to the product form, it updates the trade price and public price for the first record, but nothing after that. The second record only changes if I go in and manually retype the buy price. I set record one and...

Hi YNWA, I've done this in the past - perhaps a two step process instead of one but it worked for me. I imported the data into an Excel spreadsheet, cleaned it up so it was what I needed, then imported back into the new file in Access. That way, I had the fileds and required data and no...

Re: From one table to another? - Woohoo!! Hi David, Just had a play around and seem to have cracked it! Your help definitely much appreciated. I now have a Percent table with one record and two fields (TradeSell and PublicSell). I created the modules as suggested and set the OnLoad to use...

Excellent!!! Thanks for the help David. Quick follow up... would you say that the table I use for the percentages should one record with two percentage fields in it or two records each with one field in it? Which is the most suitable way? Thanks Jack

Hi all, Hopefully someone can help. I've been at this all week and seem to be making little steps but have been against a brick wall since yesterday morning now. I'm building a database for my price list. It is based on simply the products I have in my shop. I sell to the public and to (a...

Hi all, Unusual question possibly. I've created a database for the company I work for which has an input form when the file is opened. There are buttons on the form which allow the user to press them to see a list of records which meet the requirements. (One button says 'Windows' and it...