Recent content by fateyes

thanks smed - do you think you could give me a hand writing the expression for the query? And im not sure about how to do this - "only allocate the order# to a form field once a record has been saved." cheers

Hi, Simple request...:) I need to generate automatic order reference numbers, Starting with something along the lines of : IND_0000123 and increasing automatically from this point.... Thanks for any help Fateyes

Hi, just wondering if there are any sites around with free templates other than the Microsoft one. Cheers

Hi, I am getting this error in a subform that i am using. It is the 'Calls' subform in Microsofts 'Contact Management' database template. The only thing that I have altered in it is putting a drop down list section for the subject. This is the error i get: 'The field 'calls.contactID'...

ok, that makes some sense. However, what has happened is that i just used the split database feature, so i no longer have a flat database. I have the two related tables with all the info in them. Obviously a lot of the company info is replicated (see my previous example) - does your...

sorry - i realised that my question was pretty much table specific... still, i need to rectify the above problem...

Exactly as i thought - my problem remains the same however - on splitting some of the companies (as viewed on the datasheet) amalgamated their employees whereas most didnt (see above layout) How do i get all the companies to reduce themselves if you see what i mean... Thanks :)

Hi, My contacts database has a couple of tables in it - and one company can have many contacts. I spit this information from an original flat (1 table database). Some of the companies kept all the contacts linked, while some kept the same separation. (i.e Smith Ltd + Joe Bob Kevin...

Hi, My contacts database has a couple of tables in it - and one company can have many contacts. I spit this information from an original flat (1 table database). Some of the companies kept all the contacts linked, while some kept the same separation. (i.e Smith Ltd + Joe...

perfect thanks :)

How do i put my combo box entries in alphabetical order? They are being looked up in a table... Thanks

Hi any help appreciated, On my form I have created buttons for all the different ways of accessing records. On the move to next/last record buttons how do i make them scroll fast when you hold it down? (Like it does with the default record scrollers) Thanks

:rolleyes: figured it out

I have made changes to my design master, having added a new field to a form, a new query, and a new form for the query. Synchronising only seems to add the field and the form to the replicas, but not the query. I have tried recreating the replicas, but the new query still does not have the...

Hi, I am using the Contact Management template provided by Access, but want to make a few changes.... How could I set up an alert system within it to display to the user who needs to be called? I guess I would need a new field to type in when they need to be called back (date and/or time)...