Search results

Try using the URL in the backend table linking \\servername\folder\folder\BEfilename.accdb

Pat, if say the particular business has prices which are fixed each calendar year, but differ from year to year, then I cannot see why the price cannot be be determined by the date of the order from the pricing table (PriceID, Price, PriceYear) in any future report. Discounts and any other...

If you really must have an unbound form, open a recordset with all the values rather than having all those lookups.

As your price table enables the of the price applicable to any order because you can determine the price applicable at any date, storing the price in the order table is redundant. Having noted that, I would have probably decided to store the price in the order table to facilitate reports.

You are trying to change a file name to 03/26/2022.....pdf It's an invalid file name if forward slashes are included. Use a dash?

It could be worse. How about 30 minute change every 3 months.

I have encountered problems in the past with certain organisations where there's some sort of screening software that prevents transmission to or from their sites. I have been able to get around that by zipping the file and then changing the extension of the file name.

Or set an object to the sub form dim frm as form set frm = Forms!frmMassInput.fsubMassInput2.Form txPartner = frm.CustomerID Not saying this is better but same result

For the future you cannot embed an if/then/else/endif within a line of code. However, you can insert an IIF statement which has the syntax iif(condition, result if true, result if false) So you could have used vba stuff _ & "This is to acknowledge that we " _ & "received your payment of " &...

There is increased risk of corruption if multiple users are accessing the one FE database.

When I got solar panels installed about 18 months ago, I also got a product that measures the power use of various circuits. Usage is measured by CTs (current transformers). So I can measure the power consumed by the AC, the oven and circuits in the kitchen power string. How much power do you...

The way I heard this was that the Pope was visiting America and first stop was New York where he was assigned a woman driven chauffeur car. The Pope wanted to drive and got a bit exuberant driving too fast which attracted the attention of a highway copper. When the patrol man pulled over the...

@Gasman, hear hear. Spot on. Give someone a fish (query) and it feeds them one meal. Get them to learn to fish (learn to write queries) if they are willing and they can feed themselves forever.

But what about before the texts were written? And before science, incomprehensible things like natural events of flood and drought would be explained by supernatural forces such as god or gods or whatever whatever tribe/culture decided.

Re the reference to the village story teller passing down the collective history to children (and future story tellers), it reminds me of the first world war British story of the message passed down the trench by one person after another to the next from the front line to head quarters. It...

Only physical cash you have is not digital.

Sydney is a great spot. So many places along the harbor. I'd even go with the other half with a credit card to go shopping.

Supply is only one component of price. The other is demand. World oil supplies are a little short these days but I don't see the price of gas falling.

If the table has already more than the number of records to be added, how about one line of code Public Sub Command134_Click() Currentdb.execute "INSERT INTO Purchases (Field1, Field2, Field3) SELECT TOP " & Forms!Purchases!Quantity " & _ Forms!SCA_Add!Val1 & ", " &...

See #3 first line in this thread