Output To Ports

Nov 5, 2005

Hi,

Not sure if this is right forum, but here goes.

I am looking for advice on sending data to some electronic equipment via a data cable using a port on the computer.

The access form is complete and just needs to be able to output the data to the port.

The electronics are waiting for data in the following format:

8 Bits - Address (1-41)
followed by:
8 Bits - Data (0-9)

What route would you advise I take for accomplishing this task.

Can it be done direct from VBA or do I need to enrol a third party DLL or VB program?

Any advice is welcome.

Regards

Daz....

View Replies


ADVERTISEMENT

Datas Collection From "virtual-com" Ports To Access

Jun 5, 2006

Hi, I have a problem whit datas collection.

I have next devices, The NPort W2250/2150 Wireless Serial Device Server (http://www.moxa.com/product/NPort_W22502150.htm) and bar code rider which is connected to the Nport.

I can communicate to Nport using virtual COM-port. Bar code rider sends a number codes. I would want to move the datas from virtual COM-port to Access.

What is the best way listen a COM-port and get the datas to Access? operationg system is Win98 and Access is 97.
All information are welcome! :)

Thanks

View 13 Replies View Related

Reports :: Output To PDF Different Than Printed Output

Aug 20, 2013

I'm using Access 2007 SP3.

Whenever I export reports to PDF, the output appears zoomed and clipped. No extra pages are generated as they would be if I'm going over margins, it's just the report is clipped.

The report looks perfect in preview mode, and it looks perfect when going to an actual printer. However, when using OutputTo to save it as a PDF, this is when the report content is clipped.

Here is the code I'm using:

DoCmd.OpenReport MyReport, acViewPreview
DoCmd.OutputTo acOutputReport, "", acFormatPDF, "MyReport.pdf"
DoCmd.Close acReport, MyReport

I open the report in preview mode first so events are fired that show/hide various objects based on fields in the recordset.

I've tried reinstalling, and I've tried this on two different machines, one running Windows 7 and one running Windows Server 2008...both with the same results.

View 5 Replies View Related

Output To Xls

Feb 12, 2008

I have a sql string that is used to populate a form and now I'd like to export that set of records to a spreadsheet but I can't get 'OutputTo' to work. It wants a predefined query name - !? Any suggestions?

View 5 Replies View Related

Output Qry

Jun 22, 2007

guys the below works a treat on a single qry -(pinched from samples) however I will have 20-30 qry that I want in this 1 workbook all on seperate tabs .
Now I have also tried getting this done cross refer to "qryto excel automation" and have had some particual succes - but does any one know how to do this

DoCmd.OutputTo acOutputQuery, "Query1", acFormatXLS, "Tbl1XLS.xls", True

background

I have multiple currencies and multiple taxes on these currrencies

so Sterling
may have 5% tax , 17.5% and Tax n/A (and others) Dollars same, Euros same

so I need each currency and each tax in a seperate sheet int he same workbook

i am happy to write 1 qry for each currecny/tax
inthe exampel above Sterling 5%
sterling 17.5% , sterling Tax/Na - would be 3 qry

so I will end up with about 20-30 qry depending on how many tax's and currency I end up with
unless soemone can come up with a better solution :eek:

View 1 Replies View Related

SQL Output

Jul 13, 2005

I've created code to export data from a query to a spreadsheet and it works fien. My question is, is it possible to set up an SQL statement in code and export the results of the SQL to a spreadsheet instead of using the saved query?

View 1 Replies View Related

Report Output

Jun 22, 2006

I have a table with a field for gender and iit is populated with "m" for male and "f" for female.

I have created a report and would like it to display the word male or female for the m or f.

Is there a way I can do this in stead of doing a find and replace on over 10.000 records.

Thank You

View 4 Replies View Related

Input/Output

Dec 1, 2007

Input/Output


I’m reading “Selecting the Data” from Running Microsoft Access 2000, pp. 87-94. The confusing part is the input/output explanation. When I think of input I think of typing, keying, or entering raw data into the computer. Output to me is information displayed or printed.

Okay, here is what was printed:

“A data item is an input for a task if you need to read it from the database (but not update it) to perform the task. For example, a customer name and address are some of the inputs needed to create an order. Likewise, data is an output for a task if it is new data that you enter as you perform the task or that the task calculates and stores based on the input data. For example, the quantities of items you enter for an order are outputs; the shipping address and phone number you provide for a new order are outputs as well.”

The above is confusing me. Can anyone explain it better so this dummy can get it? Thanks!

View 5 Replies View Related

SQL Help - Query Output As CSV

May 4, 2006

Hi,

I have a select query that selects certain customer email addresses and
I want to output the results as csv, which can be used directly in a "To:" field to create a group email.

The SQL of my query is:

SELECT [Customer Details].[Email Address]
FROM [Customer Details] INNER JOIN [Orders] ON [Customer Details].[Customer ID] = [Orders].[Customer ID]
WHERE ((([Orders].[Licence Declaration])=No) AND (([Orders].[Licence Status])="Unlicensed"));

I have found some SQL code on the internet as follows:

"SELECT Field1, field2 FROM table WHERE field1='" & [FORM]![PARAMETER] & "';"

but adapting my code with that is a little bit beyond me...can anyone help?!

Cheers,

Dave

View 3 Replies View Related

Output To Excel

Aug 9, 2007

Hi

If I open a query in Access and uses the "Export to Excel" button everything works out just fine.
But when I want to make the export with a button using the code:
DoCmd.OutputTo acOutputQuery, "qryToExcel", acFormatXLS

I only get 255 chars from the PM-fields to excel.
Can anyone help me solve this problem?

I also want to make some filtering, with code string, to the query before I export it, could use some suggestions there also.

Thanks in advance

View 5 Replies View Related

Query - Output To Cmd

Aug 16, 2007

Hi,

I have a query which pulls key fields from a Table and exports to an excel file through the Output to cmmd.

In the table, i have defined a few fields with Look-up criteria and Combo / LIsts. When the Excel sheet is created the Lists are not downloaded. The purpose is to scrub the data and provide users an excel sheet for update of the Combo box for upload in another MS access table.

Please help, this feature is extremely critical for our work. Thanks in advance.

View 1 Replies View Related

Getting Correct Output

Jun 29, 2005

Hi guys,

Attached is a real simple database. What I want to be able to do is insert new payment details, and I have a couple of issues.

I have two clients and need to be able to select which client I want, select the payment details from the drop down list and enter in some appropriate amount.

Its been a while since I've created a db from scratch so this is obviously where I am having my difficulties. However I think I need to use a sub form.

How can I input the details as above, and how can I always get the combobox to default to the first entry in the list rather than defaulting to zero?

Thanks for the pointers.

View 3 Replies View Related

Output Sum To A Form... HELP!!!

Sep 21, 2005

I've got a huge problem. Lots of questions I need answers to, but I'll start with this. I have a client I was doing some web design and basic Access work for, and now they want this sorta-complicated database and I'm getting lost.

It's a big customer complaint database for a big manufacturing company, a local branch. I have all this data in one table because that's what they want.

One of the items is whether or not the company has a debit with a particular complaint, and, if so, how much it is.

The thing is, this debit number (currency) might change (update), but they want a YEARLY and MONTHLY report on "how much money we've lost, altogether."

Where do I start with that?

Big thanks to anyone who can lead me in the right direction. I have some experience with Access, but I'm by no means an expert or programmer.

View 1 Replies View Related

Disable VDU Output

Sep 9, 2006

Hi Everyone

Does anyone know how to disable the vdu output to the screen when loading multiple forms etc.

I have an annoying flicker when my main form is reloading.

Thanks in advance for any help,

Kindest regards

Tony

View 1 Replies View Related

Output Report

Aug 8, 2005

I have a control button on a form that outputs the current record to disk using an on click event. The user currently has to select the format (rtf) the path and the filename and I would like to be able to automate this process.

The format should be rtf, the path will always be the same and I would like the file name to comprise the unique record number (4 digits) followed by the current date string (format ddmmyy).

I think is just a matter of setting some parameters after the DoCmd code event that saves the report to file but I have had a go but can't get the syntax right.

Any ideas how to automate this process to eliminate the risk of user errors?

Thanks

Andy

View 2 Replies View Related

Output Of A Report To .csv Format

Nov 14, 2005

I have a report and wish to convert the output of this report into a .csv file.

Can anyone help?

Thanks

Paul

View 9 Replies View Related

Output To An Excel File

Nov 24, 2005

I am having a problem getting Access to output to an excel file.

I want to take a form that I have that has 20 or so records with 6 or 7 fields for each and put it into an excel file that is formated the way I need everythign to look.

I also need it to make the file name such as CCCAAAMMDDYYYY (3 letter company abbreviation,3 letter initials and then todays date) I am thinking that the company abbreviation will be pulled from a query, then initials will be a form that opens, and the date can be pulled from access' date function.

I tried using vb code and doing an output to comand but that did not work.
I am confused someone please help if possible.

View 3 Replies View Related

List Box Data Output

Feb 21, 2006

I have a list box control on a form which is being populated by a query. It is showing bookings that are placed on three shifts (AM, PM, Night shifts)...the list box is working fine...

- what i'd like is that the output in the listbox is seperated by shift (maybe having a blank line when shift changes, or different text color for different shift, or different background colour for different shift? )


i'm not quite sure if this can be done...or maybe there's another way out ? any ideas?

thanks!

View 4 Replies View Related

Excel Output From Form

Nov 10, 2006

I have written some code that will output to a spreadsheet in a given location:

how can I rework this code so that the excel output displays on screen rather than saving to a specified location:

Code Written:

Private Sub outputToExcel_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "C4C Period Final", "\uk.michaelpage.localdfsGroupDataNSCHElite Database ReportsGross Cash For Car.xls"
MsgBox "C4C Period Final Exported"

End Sub

View 1 Replies View Related

Report Output Impossible? =(

May 10, 2007

Hi all,

I was wondering if this was possible to do at all using access or ideas on how to do it in any other way.

View 3 Replies View Related

Output An OLE Image To A File

Mar 31, 2008

Hello, all.

I haven't worked with access in about 2 years, so I'm a bit rusty. I was wondering, what is the easiest way, if any, to output an image stored in an OLE object field to a file, like a bmp to be edited say in paint or something via VB code?

View 3 Replies View Related

Output To A Text File

May 26, 2005

Hi all! I'm not sure if this is the correct area to post this in, but hopefully it is!

I have a Microsoft Access database, and I need to output the content of one of the tables in a specific format-the table contains a Name field, a Description field, a URL field and an Alt Text field, and I need it to end up in a text file in this format:

NAME|DESCRIPTION|URL|ALT|

Where each line of the text field is a different product, and the content of each field is separated by the | symbol (whose name escapes me right now).

Anyone that can help?

Kevin

View 2 Replies View Related

Output A Zero When No Records Are Found...?

Jun 15, 2005

Hey everyone,
Even though I'm going to feel like a moron for not knowing this I'm hoping there is a simple answer. I'm far from a master at access, and seem to be having a little trouble when it come to formatting the output of my query. I have a database made the keeps track of about 200 hundred crime reports. I want to be able to do a query that will output the 15 possible crimes as rows, and then have 4 columns which are the locations of where the crimes happened. And then for the results have how many of crime where commited there. Pretty much in an excel format (see below example). However there are some crimes that have never happened. So there are no records of them. Unfortunatly when i do my query since there are no records, they are not even listed. I need them to list the crime, and place zeros if there are none. Since this probably isn't to clear I'll put a little example below.

Data:

Robbery: 4 on campus, 5 off campus, 6 in city, 0 in apartments
Rape: 0 on cmpus, 3 off campus, 4 in city, 0 in apartments
murder: 0 on campus 0 off campus, o in city, 0 in apartments

When i do my query it looks like this

*********On Campus****Off Campus****In City

Robbery******4***********5***********6
Rape********************3 ***********4

*Notice it doesn't even list the apartments since there are no records that match, the same with murder.

I need the output to look like this:


*****On Campus *****Off Campus ***In City****apartments

Robbery****4 ************ 5********6 ********0
Rape*******0*************3********4********0
murder *****0*************0 *******0********0

Any ideas? Thanks!

View 2 Replies View Related

Show Field Output Name

Feb 9, 2006

I ahve a table called occupation with 2 fields, one is ID (autonumber) the othet is occupation name.

I have another table with job info from sun to mon - with 7 fields for occupation lookup. e.g. monoccup, tueoccup etc.

I have a query and I pulled these fields into it, and the occupation names showed up, then I tried to build an expression and th output should have been the occupation name, but I'm getting the occupation ID.

The join shows occupation id from the occupation table linking to all 7 fields in the job table.

How can I get the expression to output name instead of ID?

View 2 Replies View Related

Supress Output Of A Column

Feb 27, 2006

Hi All,

I have a table called tblcheck which holds the following values:

IT, Yes/No
0001, Yes
0002, No
0003, Yes

I need to set up a query which outputs certain values depending on which of the IT values have been set to Yes. I need to take into account that a user might have all of the values set to Yes. So if I am outputting certain values in the query, I need to have them all set up in case they are used, but would like to suppress the output of any field which is related to a No value.

In the above example I would expect that nothing from 0002 would be output because it is set to No. How can I supress this output based on the Yes/No value. Would I have to do it using VB code?

Thanks,

Evan

View 1 Replies View Related

Access Join Output

Apr 12, 2007

I have two access tables that I am joining. In the opty table I want all records that meet the WHERE clause and in the activity table I want any/all that meet the join clause. The opty table has a one to many relation to the activity table. The join works correctly, it is the display that I am having problems with. I want the output display as an opty then under that all the activities associated to the opty in ASC date order. My problem is I have a memo field in the opty table I want to display but if I put a GROUP BY clause in the sql then I only get part of the memo field (I know why this is happening). So, I tried to leave out the GROUP BY in the sql and use the OUTPUT GROUP BY in the display section. This works except if there are numerous activities associated to an opportunity then the opportunity (sometimes) will be displayed twice with different activities listed. Can some please help.

If I use the the ORDER BY, and put CDATE(acty_begin_dt), I get a NULL error. Which, I assume is because some of the opty's may not have an activity associated to it.

Below is the code I am using and it works fine except, the activities are not in the correct order. (I am using this query in a cold fusion application using access db)
Thanks


SELECT opty_row_id, opty_name, opty_created_by, opty_stage, opty_type, acty_type, acty_created_by, acty_status, acty_opty_row_id, acty_desc, acty_comments, opty_primary, opty_create_dt, opty_close_dt, opty_est_value, opty_desc, acty_row_id, acty_begin_dt, acty_end_dt
FROM opty LEFT JOIN activity ON (opty.opty_row_id = activity.acty_opty_row_id)
WHERE (Trim(opty_primary) = '#form.rpt_user_name#' AND (CDate(opty_create_dt) between #get_first# AND #get_last#)) OR (Trim(opty_primary) = '#form.rpt_user_name#' AND (CDate(opty_create_dt) < #past_date# AND (Trim(opty_stage = '01 - Prospecting') OR Trim(opty_stage = '04 - Opportunity') OR Trim(opty_stage = '03 - Qualification'))))
GROUP BY opty_row_id, acty_row_id, acty_begin_dt, opty_name, opty_created_by, opty_stage, opty_type, acty_type, acty_created_by, acty_status, acty_opty_row_id, opty_primary, opty_create_dt, opty_close_dt, opty_est_value, opty_desc, acty_end_dt, acty_desc, acty_comments
ORDER BY CDate(opty_create_dt) Desc

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved