Search results

Sorry, I must have phrased that bit wrong, I meant that I changed the form and field names given in the example code to match those in my database. After all that typing and double checking of property boxes, it's still not working!

ok, I've typed all the given code (changing the form and field names) into the double click builder in the combo's property box (I take it it means the one within the form?) but then it says about requerying the combo in the pop up form's module so does that mean I type that lot into the...

Thank you very much for the link. I'm printing it out as I type!

Most of the form seems to be working ok with the exception of the combobox for the PayingCompID on the third tab. I want it to be able to add extra payment companies when necessary to the list but each time I try selecting the limit to list edits property and altering it to no, I get an error...

Ok, I hadn't spotted that typo so thanks for pointing it out Gina. I'll go and correct it now.

Hi Gina, sorry I've taken so long to get back to you but have had trouble getting a connection to the net. The code I've got so far is: Option Compare Database Private Sub cmdPreview_Click() On Error GoTo Err_Handler Dim varItem As Variant Dim strWhere As String Dim strDescrip As...

This may sound like a daft question and I'm feeling a bit stupid for having to ask it, but from the coding list that I printed out from the website you referred me to, do I put the individual bits in for each field using the code builder in the various properties boxes, in which case, where do...

Thanks Gina. I've started to work on it but judging from the time I don't think I'll get it all done tonight!

Thanks for the links, I've bookmarked them for a closer read before bed.

Ok, I'll give that a try. Thank you Gina.

Ok, thanks for that, I can see I've got reams to learn.

I'm a newbie at this game but have you checked that the Link Master and Link Child Fields have gone in to the sub-form properties ok?

I get the bit about the primary key value being unique, but how does it only limit the database to 20 records if the other records in the foreign table are combining any of those 20 words with different information from different fields all the time?

Is it possible to use a word rather than a number as the primary key in a table which then becomes a foreign key when connected to a junction table? My reason for asking is that this would be a limited list of around 20 words and would be more meaningful to the end users if they were doing a search.

OK, I see what you're getting at. Would it make things easier if I was to move the levels field from the junction table into the trades table or would that muck things up too much? Also, if I do that how would I get on with using the sub-form for trade on my data entry form since there wouldn't...

Yes, I do have a trades table which just has the "TradeID" and "Trade" as its fields linked to the junction table but the "level" field is only in the junction table, so I don't see how I can put "trade" and "level" into the same combo box if they're in two different tables.

I think I see what you're getting at but the table I'm going to have to draw that information from only has the fields: WorkerTradeID WorkerID TradeID level so if I draw the TradeID and level fields into the combo, the only words which will come up are: qualified, improver, mate, skilled and...

I know I'm going to have to change the fields in some of my tables so that the foreign key fields just show a number instead of a description after reading some of the posts against using look-up fields in tables on here. No problems with that. So now I'm hitting the problem of how do I get a...

Ok, I've started working on the form you've referred me to now but although I told the various boxes as i was creating it where to draw their data from, I've hit a snag with the record set for the form itself as it has to extract information from two different tables (I have a one to many...

Ok, thanks. I guess I should be able to create a form which is the reverse of the one I already have.