Search results

Situation wanted within access db: 1 push button [export] 2. pop-up [save as], with browser to search for a path 3. typing a filename 4. clicking on [save] But, dont know how to do that...please advise

I have a (i hope) simple question. In our db (oracle) there are a couple of fields for making a name; I will give an example field1 = Shakespeare field2 = William Field3 = WSX field4 = Bill Field5 = Von Combining has to be as follows: William S Von Shakespeare Thanks in advance if you...

Thank you Thanks!, it works with cSTR([field])

again maybe a simple question... How to convert a numeric field to a textfield. In Crystal reports quite easy (totext([fieldname]), but don't know how to write in (good) SQL thanks in advance

Found it the function didn't had to be Date() but (PL/SQL Language) current_date; now it's working fine! Thanks for the help!

Weird; as passthrough query not working, as 'regular' query IS working I have build the query again as a regular query, linked the tables and started the query. Then the query IS working. I don't understand why the expression is not working when the query is a passthrough query? (is the query...

SQL query; date function WHERE [table1].[begindate] < Date() I used the Date() function, but i get an error #936 (missing expression); (it is a passtrhough query by the way). when i do not apply the and [table1].[begindate] < Date() after the Select....From... clause then the datasheet...

Maybe a simple question, but i do not know how to put the current date in the WHERE clause of a SQL query. The query i have so far: select [table1].*, [table2].* from [table1], [table2] where [table1].[field] = [table2].[field] and [table1].[enddate] is null After this there has to be...

Yes !! It works! Somewhere in the line (after renaming the label/textbox) the fieldname was renamed as well. I renamed the fieldname to the original, and now it works! If you were a girl i would kiss you! Thanks Neil..see you 'round.

euhm.... 1) yep; does exists 2) renamed the textbox Maybe i have to tell you that it is not about a form, but a report in which i put a textbox which displays the result (should work the same as the form though). Still figuring here, but hey What's life without puzzles? :)

Thanks Thanks Neil, I tried a new report with just the field from the table (my database) and that worked fine as well. But when i put the same expression in the report i want the expression to work in, it still says "error"; also tried different combinations...no luck..:eek: (going crazy here)...

Thanks for the answer When i don't use semi-colons the error "INvalid Syntax" appears. I noticed the difference between writing a SQL-query (no semi-colons) and writing an expression in the controlsource of a textbox (using semi-colons otherwise the expression isn't accepted). I tried your...

Partly fixed the problem.

Does anyone know the problem that in some cases (appearing seem to be random) the (master/child) links to a subreport is lost? (Access 2000). Making a or the subreport again is appearing in an unbound textbox with label saying something like "report.subreport". The only option is closing...

Hellow, I must have done something wrong. I get an #Error when using the following statement in a textbox on a MS_Access report: IIF([problem]=1;"Yes";"no") The field [problem] consists of three values, resp. 1 (Yes) and 2 (No) and 0 (maybe) (be aware, it is not a boolean) Please advise on...

I have found the solution for my problem. Thanks the help everyone!:)

Allan, I think the answer to your problem is that probably the last sentence has no <<enter>> at the end. In case there is no last <<enter>>; the first record will give a problem.

please explain: "an order with lines" :confused: Hi, Can you please explain a bit more (maybe with an example ?) It is maybe easier to understand what you are trying to accomplish.

May i add another item to your post? When using your example with the mergefields witness and question, suppose there is a category for the questions, and a witness has four questions and those four questions are categorized in two cagegories. How to make the mergeseq statement that the example...

Question. Our db is protected, in other words, when an user opens the db, no possibility to open any menu is availiable. However, if the user is smart (some are :D) then opening the db with the [SHIFT]-key held down the db opens and those users can edit the tables etc. It would be just enough...