Search results

Cheers, have reached a decision, recordsets ahoy! Cheers, Lol :D

Hi all, thanks for the help on previous problem, however my course leader has thrown another spanner in the works. I was previously doing a database in Access to simulate a barcode POS system. Because I can't get my hands on a scanner he now wants me to do a front end in VB and connect to my...

Normalisation is a bitch to learn. We lost 6 weeks at college because the guy assigned to teach it us couldn't teach for toffee. :mad: Lol :D

Your'e right, I've been looking at getting one for awhile now for my college project. many are set up straight out of the box to input directly to Office applications. Lol

In the short term set the data entry property to "yes" in the properties box for the form. his will bring up the form with a blank record ready for entry to every time the form is opened. Lol :D

Because theyr'e all form the same dbase and I'm a bad boy! ;) I know about naming controls with prefixes etc, i learnt that when I did VB last year, jst never got around to doing it in my acces forms :D On the subject of my ignorance :o can anyone reccommend a list of good VBA books? I'm...

The problem I have is I'm doing a HE course in Business IT, the lecturers take the F.O.F.O. approach to learning so I'm scrabbling around with whatever books I can lay my hands on and resources such as this (which is brill). Consequently, all my Access is self taught :eek: Thanks for your...

Thanks Modest, that's more in my line! I have a VB developers guide to ADO but I don't need to learn that yet, if at all! Thanks everyone for your help, Lol :D

Thanks mate, but that is totally beyond my comprehension! I'm still banging my head on the DO.Cmd object and associated methods. Any ideas anyone? Cheers, Lol

I was using the . to designate the sheet name in the workbook. I have one sheet to accept the data and one to plot the chart, linked to that sheet. Any ideas how to designate which sheet to export to in the spreadsheet? Cheers, Lol

Hi, as part of my ongoing nightmare dbase I want to output data from a query to Excel. This is straightforward enough, however, I want to plot a graph on my spreadsheet in Excel from the exported data. If I use the Do.Cmd acOutputTo method it any chart I have created and any subsequent sheets I...

Thanks lagbolt I'll try that one in another dbase (I'm letting well alone now it works!). WRT the .value I found that it would only work with the .value in place. Thanks again, and see my new post for more cries for help! Cheers, Lol :D

I've found the DoCmd method isn't appropriate in this case. Using the Forms[formname].requery will not work when a string is substiututed for the formname. i found the Case-Select method as below works just fine :D Private Sub Make_Booking_Click() On Error GoTo Err_Make_Booking_Click Dim...

Thanks modest, that works fine, except the requery function is not working. I've tried various combinations of the DoCmd method but am getting nowhere. Any ideas please? Lol :D

Hi all, hope someone can point out the schoolboy error I'm probably making here :o I have a button on a form, formA, when I click this button it opens a new form, form B. Data entered on form B is displayed as a summary on form A in continuous sheet style. Form B has a button it so that when...

Sorted it thanks, used the code below behind the button on the second form: DoCmd.GoToRecord acDataForm, "Query1", acLast Thanks Liv and namliam for your replies. Cheers Lol :D

Sorry, ought to mention on the actual dbase the summary form is called Query1 which derives its info from a query called Query1. On form Query1 a button brings up form Booking to allow the input of complete booking details. On Booking a button saves the new data, refreshes the data on form...

Hi, have attached database. This is a very rough working model at design stage, proper nomenclature hasn't been used yet, I'm just using it to test out design theories and my own capabilities. It is a one user program, and if movelast is the thing I want then great! Thanks a lot, Lol

Hi, got a small problem. As part of a database I have to do for a booking system for a conference centre I have a form (frmSummary) that displays the results of a query (qryT101Book), the query itself displays all the bookings for a certain room from today onwards. This form only displays a...

It's a bitterly cold day. A tramp walks along the pavement and stops outside a high class jewellers, puffing and flapping his arms to keep warm. Something in the window attracts him, so he goes into the warmth of the jewellers. He immediately begins somewhat luxuriously scratching his backside...