General Forum

i reallay need your help.can you give me some ideas or codes if you got some.the program that i need is: Justifying text can mean different things, but here we consider "justification on both sides", or "double justification", where text lines are justified both on the left and on the right. That is, all lines except (usually) the last one have...

I'm having trouble trying to find the next ID in a mysql table which is set to autoincrement. I would like to retrieve this before the record is created so I can store its ID as a foriegn key with into another table. I've tried a query SELECT Max(ID) nextID FROM screenings But I found this works until I delete the most recently created...

I mentioned earlier I'm trying to use DllImport to pull in functions from a dll. I'm using the InteropServices and ComponentModel. The issue is the compiler complaining about the "[" around the comand. Example [DllImport("declspec.dll") public static extern int da4300_CountCards(); The error is on the "["operator? I am following the...

I have a form with two subforms. The main form holds the Order Number and basic information. The 1st subform holds an abbreviated list of products in the order and the data source is a table that uses master and child fields to populate. The 2nd subform holds product details and I am attempting to use a query with one parameter to...

Hello everyone, Please help me revise this query to make it work. I don't know much about update query so I will need some help with it. Thanks, update encounter set mergedpayment = totalactualcashpayments from encounter E, paymentITEM P, encounterfinancialrecord F where (E.encounterid = P.FINANCIALRECNUM) AND...

Dim strSQL as String strSQL = "SELECT items.itemid, items.itemname, items.itemsupplierid, items.itemdescription " & _ "FROM items " & _ "WHERE " & Me.cmbSearchField Like Me.txtSearchCriteria & "*" & _ "ORDER BY " & Me.cmbSearchField & ";" Me.lstSearchResults.RowSource = strSQL I dont understand, it keeps assigning a value of false...

Hi, I want to know how to write scripts for schema changes from testing server to production server.Please give an answer asap. Thanks

ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /admin/database.asp, line 180 I am currently getting this error? I'm using an access database.

Hi there I am currently creating a Maintenance Form, which can change the status of an employee from Active to Inactive. However when I created the form I want their current status to be displayed. For instance, there is drop down box containing the name of the employee and next to it there is a drop down box with either Active or Inactive in...

Hi everybody,I’v a question in a Vb.Net 2003 program,How can save or(insert) all the rows that I fill in a datagrid to be saved in itis datasource(table)at one time ,because my insertion code just save and insert the row where the curser is on it.So,IS there a solution. With thanks, here is my code, Imports System.Data.OleDb Public Class Form7...

I am attempting to get a total of production per each shift of work, which there are 3. The below expression works fine for Shift 1, but Shift 2 and 3 are showing blank values. I rearranged the expression, but then Shift 2 and 3 show the same duplicated value as Shift 1. =IIf(="1",(Sum())/((Sum(+)*))) =IIf(="2",(Sum())/((Sum(+)*))) ...

hai... i'm doing a simple program where it will sort a set of number from 1 to 100. for 1 to 9 it sort correctly. but after number 9 (10,11,...), the sort become 1,10,11, 12...,2,20,21,..and so on. Can somebody tell me how to sort it correctly? thank you..

hi, Does anybody have an idea about how to write a general report generator module? Right now, I can create a report file by coding the specific position on a page. codes like following: print_textbox(File, Page, 100, 100, 200, 300, "Hello"); It means It prints the string "Hello" at the location starts from (100, 100) to(200,300). So,...

Accidently, I(we) deleted the Logfile.LDF in sysfiles folder on the mssql server and now can't enter the database, which status now is set SUSPECT. Before deleting the logfile I did a Transaction-Logfile Backup and there is maybe an older version of full database backup somewhere. Trying to restore database with enterprise manager,...

trying to figure out how to make this work....... read some thngs but can't get it to work. a page that shows me a list of items from a DB query with a repeat region then I clik on the "view record link" and it shows me the different rows in the address bar (page.asp?row="xx"), so i think i'm passing ther row count but the data is not...

Hi Actually my task is to select some text in bitmap file and then copy paste somewhere else may in some word document or notepad or anything. My problem is how to read text from a bitmap file (hand written document) using c#. Actually how to select particular text in a bitmap file and show it somewhere else using c#. Are there any...

Hi Everyone.. Im new using ACE (Adaptive Communication Environment).. Im trying to compile with g++ but i dont know what do i have to include as libraries for compilation.. If somebody know how please tell me.. Thanks a lot.. :confused: :confused:

hi, i want to filter fields in a table on my form but the problem is that the field (Included/Excluded) in the table is in the format of YES/NO. i dont mind if the filter on my form is in the form of a list box, option button or a check box but i want to be able to search for all records, included or excluded. the way that i have tried to do...

Hi everybody; I am exporting a table to a new txt file by using MS access 2000. But as you know we can save our export specs, and next time we can call it and can use it once more. But in my Access I can not save my complex export specs. I press the save button, everything seems OK but next time again I can not find the saved export specs. ...

I have WINXP and am wanting to output reports as pdf files automatically ready for despatch via email ... l would be grateful if someone can provide me some assistance. I have a full adobe software installed

Hello Everybody, i have application with ms-access database in vc++(MFC).while initializing database with different tables and corresponding fileds,one run time error message would throw that table name is not found even though it works properly in debug mode.as well as when i add one line Sleep(1000); in place where table name and...

I have a web page programmed in ASP which works perfectly in all the browsers/personal computers except one at my home, where I see the ASP pages corrupted: - The files received by the browser start with strange codes such as "709" or "3dcd" - There are also strange fragments of code in the middle "HTTP 1.1 .... IIS 6.0 .... ", "b-y-t-e-s",...

urgent!!!! i want to knwo how can i display 2 weeks date in combo box ? e.g today is 6/22, then in combo box, there should have date from 18/6 - 2/7 for user to select. how can i do it? one idea is set the row source, but how can i combine different date together? hope all those can help me!!!! :)

I would like to be able to set the record source of a report programatically, but I am not having much luck. I have 2 queries which could be the source depending on other parameters in the program, so depending on these parameters I want to change the record source. Any ideas?

hello... If I want to enable my PC to receive an SMS through mobile phone and do somehing (including sending new sms to the sender), then what must I learn? thank u