Search results

Hi all, I recently added a code to my forms so that I will now receive a message telling me to confirm changes to the record. When I run Analyze Performance now though I get an idea warning for each form in the database suggesting that I use an Option Explicit statement at the beginning of the...

I've found my answers and solved my issue. Thanks. :D

Thanks Bob, Validation checks? Is that more code that needs to be written? I'm in unknown waters with this. Should this be a Macro, Expression or Code? Is there a site that I could download or copy it from, surely it's a pretty common thing that people would use? I've referenced my Access...

Hi all, I was wondering if it is possible to create a "Confirm changes" dialog for a form. If I open a form at the moment and edit a field, that change is automatically saved to the table. The problem with this is if a change was made accidentally, it would be saved when you moved to the next...

Thanks very much, that looks like just the thing! It means I'm going to have to venture into unknown territory such as DoCmd & WhereCondition but I'll give it a go. Thank you.

Hi all, Is it possible to create a button that will take you to a second form that brings up the same record. Form example, you have FRM_Alpha open and enter a certain amount of data and then click the button to open FRM_Bravo at the same record number to enter the second half of the data...

FYI, What I've done is created fields "Loc1“, "Loc2“, "Loc3“ etc in front of each of their respective qty fields in TBL_Main. Then I shall just convert each of these fields on the form to a combo box that looks at TBL_StampAlbums. Just done a test run and it works fine. For the sake of my...

Thanks John, I had a look at quite a few different models and couldn't quite find one that had the same sort of scenario. I'm thinking that on this occasion it might be easier just to either duplicate TBL_StampAlbums so that I can use one for each of the six possibly locations, or, just place...

I've attached a refined db copy whch contains TBL_Main, TBL_StampAlbums and a few others. You will see approx 3 quarters of the way across TBL_Main i have an "AlbumID" column followed by columns CWUSLoc1QTY, CWUSLoc2QTY and so on. Each one of the 'CWUSLocQty' columns will represent a numeric...

Hi John, It's probably too big, it's at approx 14mb now and still in design phase. Would it help if I just uploaded TBL_Main and TBL_StampAlbums? Every time I try to move forward in full flight I hit another snag! Do you understand what I've said about the need to reflect that a certain type...

Oh, okay, Hopefully someone else might know what I need to do? Thanks anyway.

TBL_Main has very many fields, most of which are ID fields for foreign keys such as "CountryID", "CatalogueID", "WatermarkID" and such. So, I only put "AlbumsID" once in TBL_Main, but use it as a combo box as many times as required on FRM_Main and apply the alias there, is that correct?

Okay, there's a slight issue! When I try to create a second "AlbumsID" column in TBL_Main I get an error message:- "You already have a field named 'AlbumsID.' What am I doing wrong?

Thanks Bob, Just wanted to make sure I was on the right path. :D

Hi all, Can you use the same referenced ID more than once in the same table? I have a database for my stamps. The exact same type of stamp may be kept in more than one location (Album). So, I have TBL_Albums which has two fields "AlbumID" and "AlbumName". Can I use "AlbumID" in my main...

Thanks so much John & Rain, Have a great weekend.

Surpisingly enough I managed to create the query and get a successful report to run from it. However, when I added the relevant tables to the query design, there was already a join between "CategoryID" in both "TBL_Main" & "TBL_Categories". However no join for "CatalogueID" for tables "TBL_Main"...

Ooops! Sorry, didn't realise it was an issue. I originally joined ASP but have had many issues with the site since it changed. Alan has been very helpful, but I think I'll stay here. Do you know of any resources I can study to try and implement what Alan suggested about creating a query to...

Thanks Alan, I'll try to play around with a query and see if I can get it to work. Is this site linked to ASP?

Sorry you might have to explain that in a little more detail. I used the Report Wizard to create the report. If I open the report in design view, what should I now be doing? :confused: