Search results

Hi again, I tried your advice and got it to work by attaching the code to a click event on a button. Problem is, if I want to duplicate the record and change the details of the product shipped. i.e, add another item to be shipped to the same customer using the same ShipNoteNumber, but change the...

Thanx so much for the advice. If I get your drift, maybe I could put it on the "On Open" event of the form, or, if the form has to open using the present link criteria (where the ShipNoteNumber field is already 0), maybe I could put it on the tab exit etc. I am at work now so I haven't tried it...

Hi people, I understand the Dmax function, but I get an error if I open a form that is filtered. When I click a buton on the continuous form "frmBookingsShipNote", it opens a single form "frmShipNote", and it has the link criteria of "pkBookingsID". The booking may have been made a few days...

Brilliant! Fandabbydozy! works a treat. Much appreciated

Hmmm. Never thought of that. I'll try that later (when I get time, I'm at work), and let you know. Thanx a lot for the tip

Hi there, I have a report that when viewed in ReportView calculates all the txtboxes correct, but when printed, the txtbox calculations are not correct. txtPallTotal calculates if pkPackagingID is 3; =IIf([cboPackaging]=3,0,[NumberOfPallets]) which is a running sum over group. I then have a...

Hi there, I have developed a DB for use at work. I have the BackEnd on the server and the FrontEnd on my workstation. Other people want to use the Dbase and I said I would distribute a FE to all workstations that need it. The IT guy here says he would rather I installed the FrontEnd in a folder...

Hi there, I wish to distribute a dbase I have developed, with the Package Wizard in A2007. It asks me for a EULA. I am presuming it is the Microsoft Office key that it wants, (the Product Key that is on the box). I have also downloaded the Access Runtime and would like to include it, but cannot...

Hi there people. Just wondered if anyone had linked an .mdb backend to a .accdb frontend and wondered if they encountered any problems. Or indeed, if it's do-able. Oh, the frontend is Access2007 and the backend is Access2003 The data tables are exactly the same it's just that the forms are...

I didn't know a thing about database design. I bought "Grover Park George on Access". Brilliant book, I now run and manage a shipping and stocks database at work. (even though it took a year of my spare time to get it to the point where everyone could use it). Also hours and hours of searching...

Thanx again Ken, The security of the database is not a great concern, most (if not all) at work are computer illiterate, they are not even aware of holding the "shift" button down while the Dbase loads to reveal the Dbase window or stop the main form from loading etc. My boss and others just...

Thanx so much for your time and excellent advice. I will try out the code using my table names etc. My database is a Shipping and Stocks database and has 22 tables (including Look-up tables and Junction tables) so I presume the "Dim strTableNames(5) As String" would then be changed to Dim...

Thanx for your quick response Ken, As regards "custom routine or code/forms" could you elaborate a little? I would consider myself a little above beginner level at VBA, but a tad below intermediate". I am quite proficient at building forms though, indeed all of the relevant data entry and report...

Hi there folks, I have developed a Database using Access 2007 on my home PC which runs WinXP Pro and Office Pro 2007. I have then split the database with the normal frontend backend, tables BackEnd. forms etc. FrontEnd I now wish to install the front end onto a number of machines in the office...

I have developed a Shipping Database, and over the last year I have been "tweaking" it continuously. I use this database every day at work, and would be totally lost without it. All this has been achieved with the generous help from people on this forum. Both knowingly from those who answered...

Thanx so much for the rapid response, I have just been "tinkering" with the code and I managed to get this to work. I think it may be stable enough to keep it. Private Sub Notes_Exit(Cancel As Integer) On Error GoTo Err_SameNumber Dim iResponse As Integer iResponse = MsgBox("Do you wish to...

I am by no means an expert on VBA, and have only got as far as I have with VBA by viewing the excellent tips and examples in this forum. That said, I am stuck on Error Trapping. I have a form with it's datasource tblInvoices. It automatically fills in a couple of required fields when opened...

Brilliant! Fandabbydozy! Whoopieee! Thank you so much for your time and information. Worked a treat. Like all things, it's easy when you know how. Not only have you solved my problem, you have educated me in the use of "Select Case". Thank you, Thank you, Thank you.

I know Conditional Formatting has been "done to death" on here, but search as I might, I cannot find a solution to my particular problem. My problem is this; I have a report that lists (among other things) Products. There are many products, and I wish to conditionally format the product based on...

Ahhhh. That explains a lot! I can now do away with the yes/no fields for coload ans shipnotedone etc. And with the date/time field, I suppose I can put that field onto a form or report twice, and just format the fields to show date and the other time?