Search results

Hi vbaInet, Thanks for the advice... I will take it on board. I just wasn't sure if what I needed could actually be done in Access using some way out code or something. I will check out the link you posted. Thanks. I have now built and tested the solution of using a SQL statement in Excel...

Hi Jdraw, Thanks for your help. Yes, I am proficient in Excel and I could do this in Excel a lot simpler. However, I will not be running the process and therefore wanted to keep it as simple as possible, hence the thought of keeping it all in Access. Some time ago, I built a tool within...

Thanks vbaInet. I thought about grouping it like you said, but this won't give me 15 separate datasets. I was thinking that using vba, I could get the database to actually split the data into the 15 separate datasets. Another thought or question I have is that using vba, could I get the...

OK. What I mean by "split the dataset" is, lets say I have a table containing 1000 rows of sales data. One field within this table contains a sales code. For this example, lets say there are 15 sales codes (but this will definitely change). I need to be able to see/export 15 subsets, based...

Hi All, I would really appreciate any help or suggestions that anyone can give. I have one dataset (returned by a query) consisting of 6 columns of data. One of the columns is a sales code. There can be multiple sales codes within the main dataset and what I need to do is return one...

Thank you very much to both jzpw22 and jdraw. This is great!

Hi All, Please could someone kindly help me with this issue. I'm sure it is something simple, but I don't know what I'm doing wrong. All I want to do is update a table with the Windows Username of the person importing a spreadsheet. I have imported the spreadsheet successfuly into a...

Thanks very much Bob - this is exactly what I need! Much appreciated!

Hi All, Would anyone be able to help me with the following? For a report, I need to be able to get a list of actual tables within a database... is this possible? Thanks for reading! Ivan

Thanks very much to both Dennisk and Rabbie. I have used the grow and shrink controls and a page break which is working ok. Thanks vey much again.

Hi All, Please could someone kindly help me. I am creating a basic labelling report, but in some cases have missing data in one field... when this happens, I need to move the following address line up so that it appears that there is no blank line. I have tried to reduce the height of the...