Search results

Hi there everyone, I'm in need of some urgent help!!...... I have a form that has a graph on it. The form's record source is a query with fields M1, M2, M3, M4, M5, M6. On the graph I have renamed these to represent months M1 being July '03, M6 being Dec '03 and so on. I now want to change the...

Hi Everyone, I am hoping someone can help me with this..... I have a table with the following fields:- Shop_ID, Order_Form_ID, Item_Ref_ID, Month For a certain selection of shops I want to be able to count how many items there are per order form. (One Order form will have many Item Refs) If I...

Futther to this, the form has a subform on it containing a graph-if that makes any difference?

Hi everyone, I keep getting a mesage when I try to close down a form in my database-"the object is locked, so any changes you make will be discarded when the form is closed"-As far as I know I have not made any changes. It lets me close the form, however if someone else then try's to get into...

Thanks for this-I've now been able to get into the references. For some reason when I stopped the code, closed the form down and went into design view, the Tools --> References was appearing greyed out. However, when I shut down Access completely and then re-opened the database, it lets me...

Hi everyone, I have developed a small database that seems to work OK. One of the senior bosses has seen the database and asked if he could have it on his machine. "Not a problem" I said. I moved the database to a directory he could view then created a shortcut for him on the desktop. He can...

Thanks for the reply, Sorry I am a newbie to this stuff-how do I get the users' names?-I've used the Access built in security wizards. Also, the code below is what I currently have behind the button and I am not sure how I would combine this with the if statement you supplied. Many thanks...

Hi Everyone, I have added user level security to my database-this all seems fine, however I need to stop particular users' from viewing a certain form. To view the form a user clicks a command button-this searches for records based on the current record displayed. If there are no matches...

Hi Everyone, I am hoping someone can help!... I have 6 tables that I join together using a SQL Union query (there is no id that links the 6 tables to each other, but they link to other tables) Each table is from a supplier and contains the fields 'Supplier Name' 'product ID' 'Net Price'...

Many thanks for that Ken!, It was set to 'Western European (DOS)', I changed it to US-ASCII and it's worked OK! Thanks again!, Sasha

Hi Everyone, I am having trouble importing a large CSV file into Access. It just doesn't seem to be able to read the file-the preview panel on the import wizard just shows question marks. If I then go on to import the file, access just seems to lock up and freeze. It works fine on a...

Hi there, Thanks for the reply, this looks interesting.. However, problem I have is that I have access, however the users who will be responsible for updating & adding records do not have access. At the moment data is just entered in an Excel file and an auto filter used to search for...

Yeah, I guess I could of-sorry about that. I was going off what retailers describe as 'footfall' 3,400 posts in the excel folder, compared to 45,000 in the forms folder. I have posted question in the excel bit before and not had any replies. Do you know of a dedicated excel forum?

Hi Everyone, I know this is an access forum, however I was wondering if anybody knows how to create cascading or linked combo boxes in excel? I.e. Where you make a selection from one combo box, then you choices on a second combo box are restricted based on the first combo box. Many thanks, Sasha

Hi Col, Thanks for the reply. Not all tables have a common thread....... Around 7 of the tables have a 'product ID' field. 5 of these are joined together using an SQL Union query. There is then a large table which does not have the said 'Product ID' field-on this table I am running a query...

Hi Everyone, I have a question about database design. I have been a 'user' of access for a couple of years-designing queries, reports, forms etc. However, this has usually been on existing databases, never had to design a large or complicated database from scratch-until now! The basis for the...

Hi there, Thanks for the reply. I checked the capital O-it appears like this in both the report and the text box on the form. I did have a look on the help file and it didn't really offer any clues-the field on the report and the form are both text etc. Still puzzled! thanks, Sasha

Hi, I didn't think so-I used the me.bang and then just tabbed the name from the list. Sasha

Hi everyone, I'm having trouble running a report from a form... I have a command button which the user can press to view the report. In the on click event I have the following.... DoCmd.OpenReport "rptPipsCascade", acViewPreview, , "FFS Code =" & Me.FFS_COde When I press the button is says...

Having no luck!-Reduced data to a bare minimum, deleted all unneccessary tables, queries and forms. Deleted all reports. -It's still too big to post!