Search results

Thanks Bob! I've had a look at the VB behind the DB, but the DB itself doesn't work, it says "the project contains a missing or broken reference to the file 'utility.mda'" - no biggie, the VB should give me plenty of ideas

Hey everyone! Hopefully this a simple problem I have a working form with a few subforms that I navigate through. I have my stock record on the main form and quantity details on the subform Basically I want to hard code the + / - keys on the Numpad to go forward/back a record regardless what...

I have a form with stock report information and a child/subform of a linked table - tblStocktake the subform is just a standard datasheet view with Master/child linked by ReportID I have buttons which copy data from a previous report to a new report. What i'm trying to do is have those...

there are 2 fields that have to be unique for the record, StockNumber & ReportID Where it gets tricky is that there are multiple duplicates of StockNumber, but only ever 1 per ReportID, so I can't make both StockNumber and ReportID primary keys - but both together *could* be a primary key.

I'm having a wee bit of confusion with what I assume is something really basic. I have tblInvoices which contains StockNumber & ReportID I then have an append query which appends StockNumber & ReportID to tblStocktake The problem is that sometimes there are multiple duplicates if the...

Thanks all - that thread was *kind of* what i was after but not the final solution. I ended up creating another query without the WHERE and then put a bit of code to select one query or the other. Private Sub MasterFilter_AfterUpdate() If Forms!frmnavigation!MasterFilter = 0 Then...

hmm - magically it works again, although I didn't do anything. The erratic nature of this problem would suggest it's a bug. :rolleyes:

Morning all I've had a problem with my main data entry form. The form is directly linked to the table - there's no coding trickery or queries. I have a duplicate record button which is the default MS Wizard macro. (the duplicate macro is just runcommand's SelectRecord, Copy, RecordsGoToNew...

Howdy accessians - I have 2 text boxes on my main navigation page - first box selects a country - and the second box selects a report from that country. The second box has a query that is dependant on something being selected in the first box everything is currently working fine - but what...

Update: Problem solved Debug.Print reporttypereturned the values of 0 or -1, so I just update my code to use the correct values I was also having a problem where by the reports were going straight to the printer and not being viewed; once again it was just a syntax error. Private Sub...

To be honest - i'm pretty sure that Yes/No is one of the the simplest things i could of done. I'm basically using one of two reports, some countries use Report A, some countries will use Report B, they'll only ever use one or the other, so i thought a yes/no would be appropriate way to discern...

G'day Accessians My Stocktake system has 2 different reports to chose from - one ordered by issue date, the other ordered by type of issue. I've added a simple Yes/No column to my table to decide which report to open. I've attempted to sus out the appropriate VBA but i just can't get it to...

Thanks Wiklendt! I'll claim credit for putting it in a table - but credit goes to the help received from this forum to actually get it working!!! Great to see another Aussie on here too! :D

haha - problem solved i see. people on this forum are waaay too quick! :-D

not sure if it's any help, but i've had problems as I have to deal with many currencies and many number formats. I've had to create a table with explicit number formats for countries I deal with. My reports are coded to use this number format Private Sub report_open(Cancel As Integer) Dim...

I dare say the user won't be too happy, but I think option 2 is definitely your best bet! It's highly unusual to have an ampersand in an email address and I'm sure it's more than likely to cause a few more headaches along the line; especially with the sensitivity of some spam blocking systems...

I think either / or \ allows you to explicitly state characters that access reserves for other uses e.g..(abc\&def@somewhere.com) I'm not 100% sure - i just remember seeing something like it in my access bible sometime today. I've noticed in a report that if you want to print ampersand, you...

do you mean it's possible to open a subform from a report but not a form, or do you mean I should create a subform with my report's layout ? It's basically so that if i notice a discrepancy on the stocktake report, i can just double click the item on the report and open the appropriate form to...

Howdy Just wondering if it's possible to open a form to a selected record from a report? I have a stocktake/report system and what I would like to do is double click the [stocknumer] on the report and have it open on [frmStocktake]. i've been hoping that (reports!report!field) would work like...

No problemo Cheers Bob for all your help! I'd give you more rep but apparently i've given all that I can for moment :-D Your prompt responses are very much appreciated. Thank you very much!