Search results

I have a problem with two queries which I want to "merge" into one stored procedure, as I am not able to combine them with the first query as a subquery of the second one. Access-qry1 ("qryERSummen"): SELECT tblLieferanten.Kurzfirma, tblER.ERNr, tblER.Rabatt, tblER.Frachtkosten...

Thanks both of you, it is definitively a DISPLAY Problem, which I cannot reproduce, as I comes up - or not. Thanks for the link to Pat Harman which I could use as well, I'll see how this may reduce the problem. Michael

Hi! Access2010 with SQl-server 2008R2: on a form there are three comboboxes which are dependant in sequence. Entering data int the first one, gives the rowsource for the second one. Entering data int the second one, gives the rowsource for the third one. in the rowsource of the combobox...

Hi! I have a big problem when requering a form (in Access 2010 runtime) connected to SQL-server 2008 R2. a branch of our company is 600 km away and the users are connected via ODBC to the server. I have local tables but as much as possible I use stored procedures on the server. The main...

@ByteMyzer: Thanks a lot, works perfect!

Hi! I hope someone can help me in that case. I am migrating as much as possible from Access front end to SQL-Server. Same with functions. I am not able to convert this function into a scalar function on SQLS 2008: Function fncRoundToHourParts(dteWorkingtime As Date, x As Integer)...

Thanks, I found a solution by tblmytable.[Alter]. In future I will omit reserved words - for sure.

Hi! I have a problem and do not know how to solve it. In a table of a SQL-Server 2008 I have a fieldname "Alter", the German word for age. When sending a PT-qry to the server I get an error "Incorrect syntax near the keyword 'Alter'" Even when I try to set "Select tblmytable.Alter as...

Hi! Front end Access 2010, back-end SQL-server 2008 R2. Normally I retrieve a certain value by Dlookup("myvalue", "mytable",...) or strSQL = "SELECT myvalue FROM mytable...;" Set rs = CurrentDb.OpenRecordset(strSQL, 4) But is there any faster way to retrieve a single value from an...

Hi! In a SQL-server table I have a datefield with datatype smalldatetime, as I only want to store dd/mm/yyyy, but no time, so it should store only 21/01/2014 00:00:00 and not 21/01/2014 11:13:43 for example. The field gets the value from an access form with the function date() which should...

Nigel, Paul! Thanks y lot for your efforts, I will take the best of all solutions!! Michael

Thanks Nigel, that's what I wanted to avoid cause it needs 47 cases. It works but it is not elegant.;) Yesterday evening I found a solution which I can live with (exept something can help me with an array solution as I still thinak this can be solved with an 2-dim array as well, but do not...

47: digits 1 to 9, letters A to Z, the rest are signs like %-/&$, total 47. Tbls are possible, but not prefered as the code should be protected and will never change. It is about decoding numeric strings like "10348977" into Hex "03EB11A11" including a checkdigit. Therefore I need to place...

Hi! I have to decode a string into numbers and to avoid to find out the values for 47 options by select case I though about an array. Ich want to decode Number Letter 10 A 11 B 12 C 13 D 14 E 15 F 16 G 17 H 18 I 19 J 20 K ... For example the string "ADEG" would give as result 10...

Hi! Thanks for the links. I went them through, all om them on this forum, but I might have to mention that I am using DAO and I RETRIEVE a result, BUT FROM another table!! That's the strange thing. The total code is like this: I insert a record in tblInventoryMovements and want to...

Hi! Meanwhile I read a lot about retrieving the LAST generated Identity from an SQL-server table. Everythings seems to work, but I get a wrong result. It seems that SELECT SCOPE_Identity does not work with access when working with such a code for example: strsql = "INSERT INTO tbltest (...

Well, as I stil do not know, what exactly ist going on, I try to sum up what I understood. You have allready three single PDF out of one file, lets say called, PDF1.pdf, PDF2.pdf, PDF3.pdf. AFter checking something you want to combine all three PDF again and name it with the...

It should work like this: DoCmd.OutputTo acOutputForm, "Frm_RTA", acFormatPDF, "c:\test.pdf" Michael

Well, first I doubt, that your data model is optimal, as for me ONE table with 'ClientAccountNumber' and a field Salesyear (dont use the field name 'year' only) seems the better solution. But then, whatfor you use a mailmerge in publisher? What kind of data are in the publisher files which are...

What I found on this issue is this: http://www.afterlogic.com/mailbee-net/docs/getting_started_with_imap_pop3.html I did dnot test it, but reading through it should give you the methods to import mails form imap and extract attachments as well. Once done so, you can save the attachment...