Search results

I have the AE (Afterlife Edition) which does have to ability to manage such links, as shown in my attached screenshot.

Alright! You got us sold now I think Tim, and I now see clearly why you're posting on these forums and what you need from us... you need an Access Database Built!!! Ok so let's start from the very beginning... you're gonna need a table to store ghost information, such as a unique ghost ID...

Ok, so let's start by identifying your tables. You have a table to store your "Zones", a table to store your "Bays", and a table to store your "Vehicles". Now thinking of the relationships, Each "zone" can have "many bays". Each bay can have many vehicles stored over time, and each vehicle...

If you are just trying to filter the form... you can use: strFilter = me.WorkOrderID DoCmd.OpenForm "frmEquipmentTransfers", acFormDS, Screen.ActiveForm.Filter = strFilter Screen.ActiveForm.FilterOn = True I don't believe you can use the link criteria to open a form for a certain column of a...

Tim, You've stated that we have landed on the moon. In the picture you display, clearly the flag is flapping in the wind... on the moon... Please explain how a flag can flap in the wind on a moon, which has no air or atmosphere, meaning there can be no wind to propel such a thing.

I have no experience with that error message, it might be a security setting on your computer. You can try: DoCmd.Setwarnings False RUN CODE DoCmd.Setwarnings True Maybe that will disable the warning message, but I somehow doubt it. Also note that Bob's code does the same thing as mine...

I don't believe a one-to-one relationship is what you are looking for, these setups are very rare, and usually only used to decrease the amount of null values in a record, or for security. You should have a single table with all of the required fields. You can split up the information into...

Funny how this comes up from a spam post... I am curious about how barcode scanners work with something like access. If I buy a USB barcode scanner, everytime I scan a barcode it comes up as if I typed the numbers? Is this accurate? If I created a database for a barcode scanner, would the...

Instead of VBA, you can put this right into your query by changing the line: Like "*"&[Enter Supplier Name]&"*" To: Like "*"& Forms![FormNAME]![Text2] &"*" I would suggest using something a bit more meaningful than "Text2" as the name of the textbox, something like txtSupplier or...

On your toolbar there is an icon with a wand and some stars falling from it. Selecting this turns the Wizzard on, and unselecting it turns the wizard off. Attached is a picture of the icon I am talking about.

That's quite a hilarious story, just goes to show you have to do the math and make sure your assumptions are correct before you go out and plan huge things like that.

I just tested your code in a small sample with: Set rs = db.OpenRecordset("Table1", dbOpenDynaset) With rs .AddNew !FIrstName = Nz(Forms!Form1!FIrstName, Null) .Update End With and it works for me. I am using !FirstName instead of .FirstName though, with...

You're right he definitely is a troll, and you're right he's one of the irresistable ones too. :)

We think alike, I was thinking the EXACT same thing, if he really could make them turn it on, and off, with a sign, he may actually have merit. The touch sensor could have been picking up the posterboard and breezes at different intervals of the wind or something. Sadly, after sounding...

I don't fully understand what you are trying to do. Could you explain in a bit more detail? If you wish to use the fields from the main form, referenced from the subform, Forms!formname!controlname.

The discount will have to be a field in the table, and there should be no IIF attached to it (The IIF goes inside the Discount Amount). The #Error might be caused because of the naming scheme, make sure the title of the textboxes is used in the formula, I believe that's what the formula looks...

Attached is an example for you.

AH ok, sorry I misunderstood. You're IIF should be in the Amount Discount column as: =IIf([carpet or not]=-1,([Discount]/100)*[Item Price],0) Note that I did /100 because I wasn't sure if your field is really a percentage or just a number.

IIF([Carpet or Not] = -1, FORMULA, "0") IIF(Condition, IF TRUE, IF FALSE). The condition will have to use the field name or the control name, just incase it's different than the "Caption" you have shown. It seems you want the IIF inside the Discount column, IIF([Carpet or Not] = -1, "10"...

"I heard he was from England, and interested in my option." Ok, I re-read this again... how can you know he's interested in your option if you don't know his name, if he contacted you, wouldn't you have information to contact him back? Did he go on TV and announce "weird guy posting on the...