Latest Bytes Forum

Sorry for posting, something funny is going down with my newsever or network and I can only seem to post new entries. Just wanted to say thanks to Allen and Mr Fenton and Bob. Ill repost when I get it fixed. Regards John

The problem to resolve should be pretty easy for someone. I have a main form which contains a combo box to lookup various vendors. Have several reports for the vendors, but it is print all or none. So here is what I have done and would like to stay on the same track. 1. Created a new vendor query (qryVendorRpt) with only the needed...

We are in the process of converting Access 2002 tables into MS SQL. I used a file DSN located on a spot on the network I KNOW everyone has access to and it works for the lion's share of users. There are a small group of laptop users, however, who can't connect to the new tables. I can go into these machines and manually set up the ODBC...

I just added Access97 to a Win2k desktop. I created a user in a secure database, but when I try to open the database on this computer, I get the following error message: The Microsoft Jet database engine has stopped the process because you and another user are attempting to change the same data at the same time. It's the only computer...

Hi all, I have an invoice table query that returns 10 records. ie. there are 10 invoices. When I try to join a subjects table to retrieve the subject name associated with an invoice it returns 11 records. I know this is because for each invoice, there might be multiple subjects. So when I join the subject table to get the subject's name,...

An HTML version of this document is available at: http://www.mvps.org/access/netiquette.htm Feeling left out? Alone? Wondering why everyone's ignoring you? Or why you're being flamed for what you deemed an innocent post? The following tips will not only help you, they will help us help you. Please note: The latest changes to this...

Hello all, I have an Access form, wherein the user can put in some data. These data will be used in a Word document. All goes well except for the line indent .... I get the error message "Sub or Function not defined" Here is the code Dim appWD As Object Set appWD = CreateObject("Word.Application") appWD.Visible = True appWD.Documents.Add

We currently use Word documents, saved as OLE objects in the database, to print letter headings and the like. As this bloats the database, we would like to store instead the path (as text or Hyperlink) to an external Word document and then somehow, at run time, pull in the document onto a report. Does anyone have any idea how we could do...

Need to get some Pervasive SQL or Btrieve data into a Microsoft Access database? For those needing to do so, we sell a very useful tool for Btrieve and Pervasive SQL Databases. Has an explorer type interface. Lets you browse and edit your Btrieve and Pervasive SQL database DDF and data files. Lets you see everything as it's native type or...

Hi and TIA. I have a text field that holds date info (01/01/01). My customer wants to keep it a text field so I'm stuck with it. The problem I have is that several users have added the date as 01/01/20 because they thought they were entering 01/01/2003. Is there a procedure/function I can run that will find the records with /20 and update...

Using Access97 I saved a form using "Save as Report". A column of textboxes show they are un-bound in design view, yet, when I preview the report these textboxes contain data even when there is no controlsource connected. They seem to inherit the static controlsource (="LCD") from the form. I can't find a place in the report properties to...

Does anyone know where I can find a good example of a web services written in VB.Net and being called from a VB.Net windows application where the web service is setup to run server side asynchronously? Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!

I have multiple generations of a flat file database that I need to compare and update to show were rows have been added, updated, or deleted. Anybody have any thoughts on the best way to go about this. The databases are just txt files, one row per line. Is there any slick (and some what efficient) ways to do compares and data manipulation. All...

Hello I have a problem whereby I have a treeview control on one form called projecttree and I wish to clea the nodes from this control in another form The form that contains the treeview is called projecttree and the form that I wish to clear the node from the tree, (because I'm connecting to a different database) is called frmConnections ...

Hi, guys, I am confused with the preprocessor instruction #pragma. What does the #pragma mean? and what does this mean as follow? ==================== #pragma intterupt Timer ====================

Hello, i'm a newbie in access. I'm looking for some kind of sample database that does check reconciliation. Can someone assist me?

If I remember correctly (and maybe I don't), in the vs2005 betas there was a refactoring to take a magic number or a literal string and turn it into a constant. Was it removed? Or am I just not looking in the right place? Or was it not there in the first place? Thanks.

Using XML and the HttpWebRequest object, I'm easily able to authenticate an exchange user behind the scenes and retrieve a list of emails and the corresponding fields. For whatever sets of reasons, undeliverable email has something funky going on with it and I can't read the actual body of the email. What I'm really trying to do is...

Hi Experts, Could you Please provide hoew to Migrating IBM Universe Database to Oracle. Whats are the steps to be taken care and how to extract data into a delimier data file. I am Using Below systems details : UniVerse Command Language 10.0 (c) Copyright IBM Corporation 2001. All rights reserved. DEVACT logged on: Mon May 14 05:59:43...

Can I make AMV with this software? Its kinda hard to explore this myself

Hi, can u pls let me know how can i attach the taken picture to E-mail to a predefined mail ID. I m using visul studio 2005 and windows mobile 6 SDKs. Thanks in advance

I have tried calling web service using SOAP. I tried the following code. But did not work. Its giving the error. Code: protected void btnTestSoap_Click(object sender, EventArgs e) { string strSoapEnvelope = ""; strSoapEnvelope = "<?xml version=\"1.0\" encoding=\"utf-8\"?>"; strSoapEnvelope +=...

Hello! I use VS2008 and start from C# asp.net and debug a MFC dll but there is a problem. It's impossible to see value for types that are pointers in MFC. If I for example have this type CStringItem* m_pPos; I can't see the value for this variable m_pPos in the debugger for VS2008. Is it anybody who knows what I can do to see the...

hi , I am new to ace tool.i am using downloaded version ACE+TAO+CIAO-5.6.1. I got the following errors at the time of building the ace,those are error1:: libTAO_messaging_la_pollable.lo. leaving directory '/root/ACE/ACE_wrappers/build/TAO/tao' (all recursive) error 1....