Search results

:banghead: Thanx nayway;)

Tried uploading again. Did it work this time? No, Won't upload a RTF. I'll convert to Doc. OK, maybe now? Seems fine. TIA!

Hi, I think you now have no close button either. Try changing the From's Control box property to 'Yes'

Hi, Use a nested IIF function: IIF(IsNull (Date),Null, IIF(date=...,X,Y)). BTW, Date is a saved word, better practice to give your Variables/fields/Controls other names.

Hi all you experts! A client wants to convert a report I designed for him, to a word document so he can edit it. The report's Report.Orientation Property is set to 1 - Right-to-Left Relevant TextBox.ReadingOrder Properties set to 2 - Right-to-Left, and relevant TextBox.TextAlign Properties...

Hi, Pardon my question: e-mail subject is a string value. Are you asking how to to set values to a string? Please focus on the complications: how do you send the e-mail, witch object do you use? where is it declared? where is subject located? where in the form do you take the ID value from...

That should have bin: RO Number: "RO" & Cstr(30000 + my_RO)

Hi, As far as I know, Access table doesn't support having a string in auto-increment field, nor starting it from a seed other than Zero (or 1). What I would do is expose to the external system a query on the table: the table will have a regular auto-increment field (call it 'my_RO'), the...

Hi, Don't know much of these file formats, but my short experience tells me getting data from a pdf never gave me good results. XBRL is an XML type (you should read about before start using), sounds like a good place to start with. Good luck!

Thank-you, I saw your method is better and deleted my post...

Hi, You could also link the field to the table field, and have the After_Update event in the last field to be updated that is used by your calculation update the value of the TextBox using Macro or simple VBA. But, as Gina above has said, Why Save a calculated field? in similar cases I have...

Hi, Create a WS? I would like to learn how to consume a WS in ACC2003... Thanks!

Glad I could help!

Here is code I found on the web, no ActiveX, no link. Pure Win API. Put it in separate module (known around the web by the name 'basBrowseFiles'), and use according to terms. Option Compare Database Option Explicit '.=========================================================================...

Hi, You can maybe link to the excel instead of Importing it to a temp table. You avoid the 'Import Errors' tables, and can cast the data to your needs (Cint(), Cdate(), Cstr() etc...)

Hi, I hope I understand your question, you can delete a table using the 'delete' button (or other ways), and import other tables to you DB. Did I get you right?

I too have have just moved from Acc2003 to 2010, but still run mdb files in this environment. I really mean a bit!... what I saw in Acc2010 is that these tables offer calculated fields in the table level, you don't have to create a view (Query) for calculating data. I've seen this ability...

Hi, It seems to me that [Receive_Date] is assumed to be a field in the report. If it isn't, you should put there a name of a field from the report. 'Month' too, is from the function 'Len(Month & '')', and assumed to be a field in the report. (BTW, why concatenate an empty string to a string?)...

Hi again, I too have never seen web tables before... so I looked into them a bit: 1. Your condition is really IIf. 2. As you have stated, DATE() and NOW() functions are not compatible with web tables, neither is datediff. As RainLover has stated, you can use these functions in a query. If the...

Oh, and I think your function should be IIF(), not if().