Search results

Hi, this was what I tried..

Would an append query do the job? You could find out how to create an append query in the microsoft office help. From what I understand, such a query copies records from one table to another, within the same database or in another database. If there are duplicate records in the 'destination'...

Hmm. Just a suggestion: If you right-click on one of the textboxes that you can't type into and then look under the "Data" tab, is "Enabled" set to "Yes" and "Locked" set to "No"?

The advice of experts like Bob has really been invaluable to Access newbies like myself. Thank you Bob, congratulations! :D

Ok. Thanks very much George and Sam!

You guys lost me there.. I guess I haven't the experience to fully follow the discussion! I've a lot to learn about this front-end back-end stuff. :) So.. In most cases, use Access?

Truly appreciate your advice as I didn't really know the limitations of programming, all these advantages and disadvantages.. :cool: Hmm. What does it mean to develop/prototype in Access? Right now we have a version of the database that is not as normalised as it could be even though it...

Well actually this is the same database that I've been trying to get up for some time, the normal Access way. Someone new in the company (more senior than myself) prefers that we use Access as a back end instead as he'll most likely be administering the database and he's familiar with some...

Thanks very much for the advice. I'll do some reading up. Cheers

Hi, I'm wondering if it is possible if some programme, maybe in VBA, can be used to manipulate data in a database, such that the database has got several different normalized tables but no forms. Can programming be used to create some sort of interface that gets information from and enters...

Thank you very much for the suggestion! :) Hmm. When I use this method the text boxes can be editted but the changes made in these textboxes are not saved to the actual records in the table.. Does this have to do with whether the text boxes are bound controls? If so, should I make them bound to...

Hi neil and missinglinq, Thanks for your responses! :D Thanks I will try this. Regarding whether it is bound, sorry for not being very clear, I'm not very familiar with the exact terminology. What I meant was that I created them as unbound text boxes and then assigned each the value of...

Version of Access used: 2003 Hi, I have a form containing information about orders. The fields related to the supplier company info are autopopulated (e.g. SupplierName, Salesrep), based on the company number (a primary key) that is entered. I am using a combo box for the CompanyInfoTable. The...

You're welcome again! Good luck :)

You're welcome.. Yes that is possible. I found this through Google.. I don't really know how it all works as I'm still new to programming, but it did when I tried it. http://www.utteraccess.com/forums/printthread.php?Cat=&Board=89&main=1611468&type=thread This is the site it's linked to...

Not sure if this would help; I'm relatively inexperienced. To set a field (column in your table) as a hyperlink, you open the table in design view and change the data type of the relevant field to "hyperlink". In datasheet view, insert the hyperlink for a record by: right click -> Hyperlink ->...

Yeah. Sorry! :o I have tried both, actually, but i'm not sure about the differences between using a hyperlink and an OLE object, like when one might be more suitable than the other, and whether in Spentak's case here, would a hyperlink be an appropriate alternative.. Well thanks and sorry if...

Hi. Just wondering if one could use a hyperlink data type rather than an OLE object in this situation?

Hi, In case anyone ever encounters a similar situation... I haven't really resolved the problem, but what I think what I might do next is to try to make the "Select file" button invisible. Maybe by doing something similar to having, on the button to open the confirmation form (on click)...

Yup. Just to add.... :D You could set a validation rule throught the design view of the table, and set a validation text that appears when the validation rule is violated. E.g. If the validation rule is '> 1000 Or Is Null' it means the entry must be either blank, or more than 1000, and if it is...