Search results

I got the expression you entered contains invalid syntax error. I try to clear things out a bit. textbox1 is unbound textbox on a report textbox2 is from table with text If textbox2 is null then I need to hide textbox1 that I filled with text "Pending" IF I try to paste iif function to...

But textbox2 that I need to hide if textbox1 is empty is unbound, where do I need to enter the function then?

I need to create a report in it I have a textbox1 that I etiher fill or not by entering data into table. IF textbox 1 is null I need the report to display text "Pending" I entered in textbox2 on the report. IF textbox1 has text in it the texbox2 should not be displayed.

I have a table with order numbers I would like to auto increment the number part of the order when new record is added to the table. My order numbers looks like this: UZSK-0001 UZSK-0002 UZSK-0003 UZSK-0002 How to make access increment the number part?

In a normal report I have data from table like: Order number Paid --------------------------------- 001 Yes 002 NO 003 Yes 004 Yes Now I need to make report that would list all order numbers in rows. I will filter input data by...

I know access 2007 has new multifields lookup thing but why can't I just create simple lookup from 1 source to 2 destination tables?

I will use forms like you said, but how do I use object coding for filtering ? BTW if I link table 1 to table 2 and 3 like you said - when I click on a plus sign I get pop up "insert subdatasheet" where I must select table 2 or table 3. While this method shows data when I expant using plus sign...

Try http://www.whereisit-soft.com/ I have tried many packages before and this the one that I liked.

Usually, a lookup column looks like this - "Take the value stored in this lookup column, use it to find some information in another table, and then display the information from that table in this table." I need to Take the value stored in this lookup table, use it to fill two separate tables...

Thanks for the fix, I wanted to add you some points but got his error:You must spread some Reputation around before giving it to boblarson again.

That was fast :) I needed to change the code to make it work why: ConvertCurrencyToEnglish = UCase(Left$(ConvertCurrencyToEnglish, 1)) & Mid$(ConvertCurrencyToEnglish, 2)

I would do that if I knew how, I can send you the code. Send me PM with an email adress where can I send the code and I will email you the code. Thanks.

The words I need to convert do not exist on any table :( I have a query that takes data (number) from a table then uses module with script to convert the (number) to (words). Then a report is made from that query. I have tried various functions but I get error circular reference. I wan't to do...

On a report page there is no before update event :confused:

I don't wan't to look stupid but, where do I put this?

I inluded a textbox and placed the code bellow in it: =UCase(Left$([words];1)) & LCase(Mid$([words];2)) words is another text box in my report that need to convert. I hidden the first textbox and now it works fine :) Thanks, if somebody can provide a better solution that would be welcome

Could you post an example? Do I need to do this in the report or a separate module?

How can I convert a sentece in my report that it would start with the capital letter? I have: du simtai Lt, 0 ct. I need: Du simtai Lt, 0 ct. I tried to use strconv but that makes every word first letter capital.

Thanks very much I added "add new record" button and it did not worked until I changed ROW source from : SELECT items.[Example Name] FROM items WHERE items.sold=no; To: SELECT items.ID, items.[Example Name] FROM items WHERE items.sold=no; Now it works OK. :D

I have made this example database to show you my problem, I have 2 tables here: 1. "items" table that works like warehouse listing items in stock and has these fields: ID autonumber Example name TEXT Sold Yes/No 2. "sales" table has these fields: ID Autonumber Example name created using...