Search results

I take it this is not a common occurence and must be something unique to my database then? I've decompiled my database and it still occurs. I should also add that my front end MDB is connected to a MySQL back-end.

I'm developing a database and at the moment I'm the only person using it. I have a bound form with various text boxes on it. If I change the value of any of the text boxes and close the form the updated values are saved. If I change the value of any of the text boxes, but then change it back...

I should also add that for now I'm only using locally connected barcode scanners and not wireless detached readers that have to be synchronised later on.

It stays within Access and doesn't go anywhere. Take this typical example: 1) DLA-PRN 2) 12345 I would scan a barcode with the letters DLA-PRN. My function (already working) splits that into two parts. DLA designates Delivery Address and PRN designates PRN. So in this instance I want to...

Hello guys. I've got an idea for something I'm trying to implement that I suspect is actually impossible to do in Access, but thought I'd see if any of you guys knew of a way before I dismiss it. I'm developing an Access database that handles my company's orders, purchases, quotation and...

The trick is, like I said above, to design your menus in Photoshop or whatever image editing software you use, then import the images into the background of your form - making sure you link rather than embed as the file size soon spirals out of control. Then simply create standard command...

Hello. I'm developing a system using Microsoft Access 2003. I'm using linked JPEG images as backgrounds for my main menus with transparent command buttons positioned over the top of each graphical button. As can be see by the image here I keep experiencing a weird vertical glitch throughout...

Yeah this is on a continuous form. I've just noticed the conditional formatting options and while this sort of does what I want it to, I don't have enough control over, i.e. I can't define a specific colour other than what's available in the pre-select list. Is there way to run code against...

Hello, I have a subform that among various other fields displays the date an item was due to be delivered. I've written some straight forward code that changes the entire line of text to red if the item is late, or green if it's not yet late. The problem is, no matter which On Event I seem to...

Yeah that makes sense but I'll never need to delete the original quote because I'll always want to be able to follow 'the trail' backwards from an order to its origin. There's a chance I'll be building an enquiries system that comes before Quotations too, so that definitely confirms the need...

That's not gonna work in this instance because POs, SOs and Qs also have their own unique fields that don't need to carry across. They also need to get marked off as a complete or live depending on their progress so they do need to remain as three entirely separate entities. It sounds like an...

I could but I might - and generally will - need one instance of each simultaneously. Also, quotes might have the same item numerous times but with different quantities, i.e. price for 10, 100, 1000. And so obviously the PO and SO wouldn't reflect that. Nice idea though and I like your thinking.

What's complicating it for me is that I will never know how many rows will need to be INSERTED. There's always be one row for the sales order itself which is the easy bit. The unknown is however many order_details row I'll need to insert. Will an INSERT THIS INTO THAT (SELECT THIS FROM THAT...

Hey guys, I'm a relative beginner to VB having spent the last few years learning PHP and MySQL. I'm currently building a system to manage our quotations, purchase orders and sales orders. For each of the three systems there's a main form and a sub form, for example, tbl_quotations links to...

Hey guys, I have query I'm trying to run that takes a parameter from a combo box on a form. If this combo box has an entry selected I want the query to use that as a parameter, if it's blank I want the query to show all. I've tried: =Nz('[Forms].[Snapshot].[LiveInitials]','##') but to no...

Hi guys, I am trying to create a query collecting data from 4 tables as well as calculating totals delivered but it's hurting my head trying to work out all the joins can anyone help please? The 4 tables are as follows: Orders ===== OrderNumber CustomerName CustomersRef OrderDetails...

Hi guys, bit of a tricky one here and I can't seem to find satisfactory answers anywhere so hoping you can help. I have a form which contains 7 parameters. 4 combo boxes and 3 text fields. The user selects entries on any of the combo boxes or types text in any of the text fields. They do not...

Hi again John - I realise you're in bed now so probably won't see this until tomorrow. I just got the error message with your newest version of code - but I think I might know why it's happening. It's happened twice in the last hour and it always seems to happen when I'm in a different section...

Ok so I just removed all traces of the If Me.NewRecord Or Me.Dirty Then Exit Sub line but am still getting the error message. Though this time it's referring to the line: DoCmd.GoToControl CurCtl I'm really puzzled now.

John I've been through all my forms - the fields in every case are all correctly named and refer to [Tel ID] so that's not the problem, the problem for some bizarre reason seems to be down to the line I inserted: If Me.NewRecord Or Me.Dirty Then Exit Sub I inserted this as the 2nd line...