Search results

Thanks for your responses, but I don't think using the crosstab is going to work fo what I need this for. Can anyone offer any other suggestions for formatting the pivot table? Much appreciated Thanks Jo

Oh my goodness, I think i'm out of my depth here. Is it easy to concatenate my values? I understand how to concatenate text values, but not how this would work with this data. Sorry to be a pain, but can you explain how Iset up the data and whic fields I then select thanks

Thanks for the response, but a cross tab, only allows me one value option and one Column heading. Unless I'm doing something wrong. I need 4 Value options. I only showed 2 in my example, but in reality there are 4. Am I getting this completely wrong? thanks

Hi If anyone can help, i'd be grateful. I'm trying to format a pivot table in an access query, in the same way in which excel automatically creates the table....but really struggling. Think i've been trying for too long. I have the following fields Item, Date, Invoice Qty, Total Amount...

Hi all. I'm tying to manually link tables via an ODBC link, however when I createa manual link the "_" between words is dissapearing. this means that any table names with multiple words separated by and _ won't link, and any single table names will. It is the same with field names. The form...

Hi, sorry for not replying sooner. There are a couple of make table queries, but they aren't having the same effect in other companies. I use the same base database for several companies and just make a few minor adjustments to suit the client. Thanks

Hi I'm having problems with a database that is increasing in size simply by opening and closing it. I've read through the many posts on here about that, and looked through the code for open recordsets and queries etc, but can't find anything that looks like it is causing it. This is a database...

Hi. I'm trying to create a report with a chart in it, based on a query. I've been using the Report Chart Wizard, but not getting the results I want. I managed to get 1/2 way there, but the bizarre thing is that when I look at the report/chart in Design view, all I see is the sample chart (the...

Wow - so easy. Thanks very much

Apologies if this has been asked before - I promise I've been searching for 1/2 hour and haven't found the answer. I have a combo box that I need to drop down automatically on gotFocus. Normally I would use Alt + Pg Down, but in this case it needs to open/drop down automatically. Can anyone...

Thanks for the response - sorry took so long to reply, I was on holiday. Anyway. I'm still slightly confused. I've created the query which gives a list of absolutely everyone with every course. Then i've created a query which links that to the attendance table. You mentioned that I should...

Hi I'm recording information about people attending training courses. There are three tables 1 - tblStaff (StaffID, FirstName, Surname) 2 - tblCourse (CourseName) 3 - tblAttendance(StaffID,CourseName,Date) Table three is a many to many junction table as you can see. (This is a simplified version...

I SUSSED IT!, as no one responded to my question I thought I'd tell you how I did it. Surely I'm not the only one who has this problem....or maybe I am. I attached the backend of the database as an additional file when I packaged the database. Once the datbase was installed, I saved it to...

Hi Apologies if this has been covered before - I promised I have searched and not found an answer. I have just purchased the Access Development Extensions so that I can deploy my database's to users without Access. So far, I've managed to create an intallation file fine. Hwever, the database...

Hi All I've currently got a Customer Database and a PDA. Unfortunately they aren't talking to each other. Is there a way I can either get my Access DB to sync with the PDA directly, or sync via Outlook. (i.e. Sync the PDA with Outlook, and then sync Outlook with my Access DB). THe only...

Hi I have been asked to write a database that holds sensitive information (as many do) where different people have different accesses to tables/back end etc. This isn't a problem, and I can set up user groups etc. However, I've never done this on a network before. The users already log into...

Hi Can anyone recommend a cheap fax client which can be easily linked to Access. I have a client who currently uses Zetafax, but would like to find something cheaper. Any information would be gratefully received. Thanks

Hi Can anyone recommend a cheap fax client which can be easily linked to Access. I have a client who currently uses Zetafax, but would like to find something cheaper. Any information would be gratefully received. Thanks

Sorry, i've still had no response. Any help and I would be soooo grateful. A very desparate Jo Thanks for the response again. Unfortunately it hasn't worked. :confused: I have re-attached the full database as it stands at the moment. it is still very much work in progress as i've been...

Sorry Still No Response, If you have time to look at this and tell me if it is possible, i'd be sooooooo grateful Thanks A very desparate Jo