Search results

Use linked pics instead, much smaller file sizes, and easier to change without messing around with controls :)

Ah, got it working in the end. Used the MSDN help on setting conditions in code. Cheers anyway ;)

Hmm... well, it wasn't quite as solved as I thought. Got the conditional formats working, but can't figure out how to save it once its set up :( Any ideas? : Thanks in advance for help :)

Ah yes, that did it :) I didn't spot that I could change the comparison from selected field to a standard expression. Cheers ;)

Well, I got asked to do this with a datasheet view today, and I found after searching the forum that I'm not sure how to do it, and no one else seems to have done this either. Basically I need to flag a row in a datasheet subform dependant on if a date field is more than 1 month ago and if the...

I would suggest keeping the information in 3 columns. There is no point aggregating it internally, but you can always run queries that aggregate it into a single column when you run it, without changing the internal structure.

Hmm... of course it wouldn't. Should really check queries before changing them :D tblExpectedShipments.ShipmentDate>Date() is a true/false boolean expression. if you are comparing this to a date, then no you wouldn't ever get any results ;)

well, assuming that download20060602.Date is the date the payment is made, and this is null when a payment hasn't been made, then SELECT download20060602.Date, download20060602.Description, download20060602.Amount, Members.FirstName, Members.[Mid Name], Members.Surname, Members.[Memb No] FROM...

Just [Forms]![MyFormName].Visible = False should load the form and make it invisible. I use this frequently in my database to make sure that the users can only see one form at a time without having to close and reopen things.

not entirely sure, but perhaps SELECT tblExpectedShipments.ShipmentDate FROM tblExpectedShipments WHERE (((tblExpectedShipments.ShipmentDate)=#IIf([Forms]![frmSelectShipperReport]![chkOverdue]=0,(tblExpectedShipments.ShipmentDate)>Date(),(tblExpectedShipments.ShipmentDate)<Date())#))...

An empty field is different from a null field, especially with strings. An empty string is a string with no characters, except for the string terminator character (which you can't see). A null string is a string with absolutely no data in, not even the terminator. Best thing to try is to make...

Would need to know more about thetill drawer before I could say anything about it. It should have an API that lets you open and close it and get information from it. You may need to get in touch with the company you got it from to find out if the API is usable from access, and if it is then talk...

My guess is that you are getting beyond what you can do with simple queries and need to move on to VBA code to accomplish this. You can't do things like running totals with queries, as that would require a much greater of record interaction between elements of a recordset than is possible.

You seem to be running afoul of record locking. The way around it would be to disable record locking, but before you do this, think carefully about what you database is going to be used for and by. If there is ANY chance that the record could be updated by 2 people at once, you should try a...

It sounds like you need to put a requery in it somewhere, but I'm not sure where :) I have the same problem with one of my forms at times as I found the easiest way to a particular update was to delete all current relevant entries and insert new entries. This causes a #Deleted in one form, but I...

FINALLY :D:D Thanks Jacob :) you put that, and it finally clicked as to what I needed to do. Having just read about 50 different sites and none of what they suggested working, I was getting to the point of either going insane(very difficult, I think I'm already borderline anyway, if not already...

Ok, I'm setting up a new frontend for my DB, as it needs to give some different forms etc to a different person using it. I want to link a couple of the tables that are needed, and I get the message 'blah can't open the file. It is either located outside your local intranet or on an...

using a combobox isn't that much different from a text box for grabbing the value: SELECT Count(CustomerQueryID) AS CountOfCustomerQueryID FROM [tblCust-Inquiries] WHERE InquiryDate Between [Forms]![fmDatePicker]![txtStartDate] And [Forms]![fmDatePicker]![txtEndDate] AND Responsible Department...

right. this is really a job for some VBA code. What you basically want is to put some code in the AfterUpdate event of each text box, which finds the description for the entered code, and populates the description text box with the info. Its not very difficult, hope this gives you enough of a...

How about setting the picture type of the button/control to linked rather than embed?