Search results

Hi, I have some code that I just can't get over the line Dim CompID As Integer 'look for component CompID = DLookup("ID", "tblComps", "Pnum = '" & Forms!frmGoodsIn!tbScanComp & "'") If CompID = False Then 'not found MsgBox "No component found, is this a new Component?", vbQuestion, "No...

hi people, I have a module that runs when the Dbase opens. It grabs the windows UserName and places it in txtUserName on a hidden form. I also have a table for users: pkPersonID (primary key autonumber) First Name Last Name UserName etc The UserName field is filled-in using VBA when the Admin...

Hi People, I started doing some housekeeping on my UserCp by way of deleting threads that were started by me, and that were solved. I deleted three of them and gave the reason for deleting as "Solved". I then wondered if I should carry on and delete the rest, or is it better to leave them on...

Hi people, I have a form for entering details to generate a shipping note. On the form is a subform which updates when the user selects the product to be shipped. The subform shows all outstanding purchase orders for the selected product. Nine times out of ten, the purchase order to be used is...

Hi people, I think I'm about done with Normalization. If any of you kind experts would cast an eye on the table structure (attached pic), and point out for me any pitfalls you see, I would appreciate it. Thanks p.s. I know tblShipments looks a tad large but a lot of the fields are Number fields...

Hi people, I got this code from an MS help website, (can't remember where). It detects the User's idle time and closes Access if there is no screen activity for four minutes. It works great if the user doesn't open a report. It looks for the last ActiveForm and compares to the current. But when...

Hi there I would like to see if I understand this correctly. I have a Backend on a Server, and I have two Frontends (different names) that I wish to connect to that single Backend. Would I be able to use Bob Larson's FE Auto-Updating Utility to update the different Frontends as and when they...

Hi there, First let me thank all who have helped me build a functional Sales/Shipping/Orders database. I could not have done it without the generous help from people on this forum, and a couple of good books. Presently; I have one main table, where the day to day data-entry is entered...

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...

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...

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...

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...

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...

I have a Dbase set up and ready to roll, but I haven't actually created the Dbase yet with Access. I would very much like your opinion on my table layout and relationships. You can view the design here I am hoping to track shipments in and out, plus current stocks of items using Queries and...

I am almost at the finishing line with a great deal of help from here. I have now normalised the tables, built complicated queries, forms, reports, all from scratch as I knew absolutely nothing before I started with Access three months ago. I have compacted and repaired the database using the...

I know nothing of SQL, the following code is what appears after I made the query in design view then switched to SQL view; (I named the query "qryProductsShipped") SELECT DISTINCT tblShipments.Product, tblShipments.NumberOfPallets, tblShipments.PartsPerPallet, [NumberOfPallets]*[PartsPerPallet]...