Search results

I know and have seen people replying to similar posts on the net by advising to use custom menus and that is what i used to do before i learnt that there was a switchboard implementation in access. So I would like to know if anyone has successfully altered the limit access imposes (8) ? I...

Hi I have no idea what i am doing wrong but i cant seem to create forms based on multi-tables! If i create them using wizards, the forms can be seen and they have the "dummy record i created" displayed. however i cant seem to edit it or create a new record through the form! In desperation I...

I have my table structure as: personalDetails(Pid, fn, ln,...) link(pid,addressId, type) address(addressId, street...) I have a form called add participants. It has a subform which gets the addresses of each participants. It works ok for an example record that i created using tables but...

I have no idea if i did anything but I have about 5 fields in a table which are doing a look up from 5 different tables. They were all working before but now only one of them is working! In the other ones not working, when i try to use combo box, it appears empty however if i hover over the...

If i have 3 tables: personal(id,...) link(id,addressId,type) address(addressId,...) Now when I select all these fields and create a form I get one set of address details but i really want TWO! I can use "field list" in design mode and duplicate address related fields but how would access store...

Ok from a normalisation point my table is Ok i.e. only has fields that depend on the primaryId! but there are so many rows that I was thinking if i should separate the table? for example: details(id, fn, ln, addressId, dob, tel, mob, email, password, newsletter, showCV, workType, contractType...

How would I go and do this? I have 1 solution but wanted some hints/check if I am on right path To have two fields: Id, RefId... Id will be autonumber, in the form using macro/VBA (or even manually) I could copy ID value into RefId appending a letter in front?

OK on simple joins, I use queries to link tables and then build forms so that users can add data etc. However I am having trouble doing this for complex relationships! I have: Personal(Id, name) personal_Address(Id, addressId, type) Address(addressId, .... ) Institution(InsId, name...