Search results

Good morning all, I am designing a fairly simple database for a client. Top level, they have asked for a couple of forms to be designed for inputting data into tables. They have a set number of admin people that they would like to be able to have access to all tables within the database - the...

Thanks to you all of you for your replies

Sorry for the rubbish thread title but I couldn't what else to call it. I am appending to an empty table customer name, brand and then sales. So, 3 columns. I have 4 brands in total. Some customers do not buy all of the 4 brands but I need to display the 4 brands, later in a SELECT query. For...

Thanks for your help - I have just spotted a back up which I can open successfully so will use this version

Hi everybody, I have found a lot of stuff online about this but not a solution to it preventing a database from opening In the properties, I seem to have the same permissions as my other databases. The database contains one table and a few append to queries that are based on a crosstab query I...

It's in File>Preferences...... Cheers Andrew

Ok thanks, can anybody else help please?

Thanks Minty but I cannot see how to get to these options?

Hello everyone, I have been using PG Admin 3 to run SQL queries and then exporting the results as pipe delimited text files. I'm now using PG Admin 4 (through no choice of my own) and the layout is very different. I can only see how to export my queries as a csv. When I say export, I mean...

It worked!! I love you!!

Oh I see, I will try again - thank you

Not sure what I'm doing wrong here. This is my table; .... here is the error that I get; What am I doing wrong here? Thanks in advance Drum

Thanks for your response. Do I literally copy and paste your code into a macro, changing the table and field names?

Hi all, I have found a handful of instances on the web where people have asked about this and I even found what appears to be a solution at https://sfmagazine.com/post-entry/october-2015-access-fill-down/ However I cannot get it to work........ This is an example of my data; Does anybody...

Thanks to everybody for their help with this one. I had to abandon the project in the end and have only just been able to come back and reply. All the best 'Drum

This is for audit purposes so I need to show that I have randomly selected the invoices with no intervention

Hi, I have spent a long time trying to find a solution to this but I'm struggling.... I'm not sure whether it is the distinct function that I need but I am hoping that somebody here can help. My dataset is invoices. Specifically, invoices for Belgian customers. Some of these invoices are for...

Yes, I think you are probably right on this. I think I am going to open my backup database on my second monitor as a reference and simply re-add all of the items to each menu again. Out of interest do any of you know why this may have happened in the first place? Thanks to all of you for...

Thanks Arnel, I'm beginning to understand what you mean now. I back up all of my databases weekly so I do have a back up copy. Is it possible for me to somehow copy the system table that contains the menu from the back up copy? Where cn I view these tables? Thanks in advance

The menu is created in the Navigation Options. You call the menu what ever you like and then add objects such as queries and macros into the menu. Access actually creates a shortcut to the object and you can name the shortcut what ever you wish. So query A0201-Gross-Turnover-YTD could be...