Search results for query: *

Hi there, we have an SQLtable "item" that contains a full range of items. We usually assign 6-digit-numbers as [No_]. I already have a script, that finds free numbers: Select t.[No_]+1 as LueckeVon, (Select MIN(CAST([No_] as int))-1 From [BODAN600].[dbo].[BODAN Gh_ für Naturkost GmbH$Item]...

This is about SQL Anywhere 11 - with Visual Studio 2008 - via ODBC I try to create a query with filter to a datefield (LAST_CHANGED) > Yesterday. As from MSSQL I know "Today()-1" --- this does not work here. I also tried "> Dateadd (day, -1, Today())" - Invalid expression Does anybody have a...

Linked SQL-table qry: SELECT [dbo_GmbH$Sales Shipment Line].[Order Picker], [dbo_GmbH$Sales Shipment Line].Quantity, [dbo_GmbH$Sales Shipment Line].[Gross Weight], [dbo_GmbH$Sales Shipment Line].[Net Weight] INTO Kommi_1 FROM [dbo_GmbH$Sales Shipment Line] WHERE ((([dbo_GmbH$Sales Shipment...

For this example: Table SalesLine Field [orderno.] Field [Debitor] Field [item] orderno. - Debitor - item 10001 12345 1010101 10001 12345 1122334 10001 12345 1111111 10002 12222 1010101 10002 12222 1122222 10002 13344 1231231...

Hi all, Szenario: SVR1 - W2K8R2, NPS, Routing&RAS --NPS Proxy redirecting to SVR2 SVR2 - W2K8R2, NPS CLI1 - Win7SP1, NAP Client enabled L2TP VPN works from client via SVR1 to SVR2 As soon as I implement a Windows Security rule ... integrityrule - networkrule on SVR2 saying "Client Firewall...

As I am not familiar with java at all, maybe someone has got a hint for me - this is, what I want to do: - Having an image (img01.jpg) on my webpage - on top of that another image (img02.jpg), so that img01 can not be seen - moving the mouse over the image area just shows a small circle of...

Hi, maybe anyhone has got a hint for me: Having Access2010 with a main form, from where I am able to call other forms. (Main Form -> New Record, Main Form -> Records marked as X etc.) So these buttons just open a new form with a filter. It happens from time to time, that I try to open another...

Just a quick question, having a domain hosting provider, I want to log the faulty mail system he provides to be able to quit before end of contract. Is there any simple tool or script for eg. Outlook that sends a Testmail eg. every 10 minutes through a configured smtp server? Send as...

Hi, Original issue: list of recipients should receive mail with pdf attached. I already found a solution for that in general, but as I do not have any clue about vba, maybe someone could help out at the missing point. I have an Excel table containing the recipients(A), Subject(B), Text(C) and...

After upgrading the client to Win7 I have got the following issue with odbc: As long as I put into the ODBC.INI in the registry te full path to sqora32.dll and write protect the key C:\Oracle\product\11.2.0\client\BIN\SQORA32.DLL the application is able to connect. So far so good. "The...

Access 2010 The following procedure is on the "after update" event on a checkbox Private Sub FertigX_AfterUpdate() CurrentDb.Execute "INSERT INTO LapLog ([LfdNr], Aktion, Zeit) VALUES (" & LfdNr & ", 'Fertig neu: " & FertigX & "', Now())" If FertigX = True Then If MsgBox("Wirklich...

Hi, What I have is a form, where I am able to select a person from a combo. Form then displays main data (PC-Name, Room, phone etc.) and a contiuous subform, displaying info about what was done with this user. - Let´s call it "ticket system" In the subform I sorted the last entry to the top -...

The next one from me ... I have some code in the on open event on my switchboard, that opens another form. Both are PopUp = Yes, so that the switchboard comes in front. I tried to docmd.minimize before opening the other form - that works, but a) Howto automatically maximize switchboard after...

A textfield in a continuous form is bound. The field contains "Hello Dolly how are you? I hope you are fine" As the width on the form is only 5 cm it displays "Hello Dolly ho". Having the focus I can go further to the right and scroll the whole text, so it is not truncated because of the...

Unfortunately I do not find any hint for what I am trying to do: Having two tables FE_Version and Config. Both have field Version - if they match everything is fine. I would like to have a button "Check Version" that checks the fields and pops up a message saying "Please update your frontend"...

Hi all, is there any "built-in-solution" for the following scenario? - Form - field "Finished" is set to true - Messagebox is sent to accessuser "ITDS" I found an external solution, but am still wondering if there is any internal possibility. -------------------------------------- >>>>>>...

Is there any possibility to have a search-field to enter something and to have a result list that diplays all records that match the entered text in ANY field? eg. name, surname, city -> entered "mil" -> result Miller Martin New York Rodemill Robert Washington Fine Fran Milchester Bond Emil...

After browsing around and testing several things, I am not really coming to the final ... Having a from containing a subform "frmSUB". What I would like to have: Click on the "Name" field in the subform should open a new Form "frm_DispDetail", displaying the details of the selected record...

Scenario: - Form with Combo-Box - selected "User" will display details in detail section - subform in detail section that displays the "user" if it is present in another table (SELECT [Fehlende].[User] FROM Fehlende; ) How to hide the subform if it does not contain records/data? Thank you...

After I sorted, hid and moved my applicaton icons around I wondered, if it would be possible just to save the order and appearance off the icons to restore it eg. to another BB. It should not change any Theme, Skin, etc, just the order of the icons in the menu. Any hint for that? Or is it not...