Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 21 of 21
Search took 0.01 seconds.
Search: Posts Made By: crisan
Forum: Access VBA October 25th, 2005, 07:34 AM
Replies: 2
Views: 3,030
Posted By crisan
"Type Conversion Failure" when using TransferSprea

Hi! I'm trying to import an Excel sheet file into an Access table using Docmd.TransferSpreadsheet method. The big issue is that I always receive an error when importing and a...
Forum: Access September 27th, 2005, 01:55 AM
Replies: 2
Views: 1,354
Posted By crisan
Ok, Boyd , but how should look the error handling...

Ok, Boyd , but how should look the error handling code from Func1 to stop execution if an error ocured in Proc1(which is a function now, let's say Func2)?
Whith the code below, every time I get an...
Forum: Access September 26th, 2005, 07:02 AM
Replies: 2
Views: 1,354
Posted By crisan
Error handle - stop exec. of parent function

I have a Function Func1 which calls a procedure Proc1. Func1 find all ".txt" file names from a folder and import them onebyone. When an error occurs in Proc1 (for ex. a wrong format of one of the...
Forum: Access September 15th, 2005, 09:28 AM
Replies: 10
Views: 3,377
Posted By crisan
Kevin, I'm from Romania.

Kevin, I'm from Romania.
Forum: Access September 15th, 2005, 07:48 AM
Replies: 10
Views: 3,377
Posted By crisan
Thanks, Kevin! It looks like a good starting...

Thanks, Kevin! It looks like a good starting point. I will try to adapt this to my needs.
btw, which is the safest way to prevent sorting of the PayData table? I want to avoid the accidentally...
Forum: Access September 15th, 2005, 04:53 AM
Replies: 10
Views: 3,377
Posted By crisan
Kevin, first of all, thank you for efforts to...

Kevin, first of all, thank you for efforts to help me.
Ok, with this crosstab I have all the information I need. This is good. The major problem is that I need to export this information into a...
Forum: Access September 15th, 2005, 04:11 AM
Replies: 10
Views: 3,377
Posted By crisan
kevin, i tried to make the case as simplest as...

kevin, i tried to make the case as simplest as possible. In fact, I have to do with more complex tables, with many fields and a lot of grouping levels. I need the VBA code for this simple case just...
Forum: Access September 15th, 2005, 03:19 AM
Replies: 10
Views: 3,377
Posted By crisan
Exporting related tables to excel

Hello! I have to export two related tables (EmployeeData (ID,Name,Age) and PayingDate(ID,Income,Date) from Access to Excel.

The excel table should look like this:
1 John 35 ...
Forum: Access September 10th, 2005, 09:59 AM
Replies: 12
Views: 1,654
Posted By crisan
Kevin, it works perfect! Thanks a lot!

Kevin, it works perfect! Thanks a lot!
Forum: Access September 10th, 2005, 08:16 AM
Replies: 12
Views: 1,654
Posted By crisan
Kevin, these PID's are text type. The only...

Kevin, these PID's are text type. The only important thing I forgot to mention is that PID is Primary Key in each of these 3 tables.
Forum: Access September 10th, 2005, 06:58 AM
Replies: 12
Views: 1,654
Posted By crisan
Kevin, this will be run from a button. TEST...

Kevin, this will be run from a button.

TEST DATA.
Products table:
PID NeededQty
AM002C 400
AM003C 520
AM004B 335 ...
Forum: Access September 10th, 2005, 06:29 AM
Replies: 12
Views: 1,654
Posted By crisan
Dartcoach, 1.I don't have any prefference in...

Dartcoach,
1.I don't have any prefference in solving this issue, can be a querry or VBA code as well.
2.This application will be run twice a day, every day.
3.No, I don't have to update the stocks...
Forum: Access September 9th, 2005, 07:35 AM
Replies: 12
Views: 1,654
Posted By crisan
Smart ideea needed

Hello, everybody! I need a simple and smart solution for this case:
I have two tables: Products, with ProductID and NeededQty fields, and SupplierStocks with 6 fields : ProductID, StockA, StockB,...
Forum: Access June 24th, 2005, 05:58 AM
Replies: 1
Views: 951
Posted By crisan
'CreateField' issue

I have to create about one hundred tables , each of them with at least 230 fields.The field names are "very incremental" (i mean a000_01, a000_02, a000_03 etc), so i prefer to generate field names...
Forum: Access June 2nd, 2005, 07:07 AM
Replies: 0
Views: 706
Posted By crisan
Debugging Acces95 macros

Hello! I need a solution which allow me to cofirm each step in a macro from a MSAccess95 database. Is there a way to convert an Acc95 macro to module? Or, maybe, some code which ask for my...
Forum: Access May 25th, 2005, 05:31 AM
Replies: 1
Views: 895
Posted By crisan
Outputting table permissions

Hello! I need to know what permissions are set for each table in my database . I know I could use Tools/Security/Permissions for that, but there are ~200 users and 100 tables in my database. So, i...
Forum: Access May 11th, 2005, 07:58 AM
Replies: 2
Views: 1,938
Posted By crisan
Thanks,mmcdonal! Your solution with the running...

Thanks,mmcdonal! Your solution with the running sum on a report works great! Thanks again!
Forum: Access May 5th, 2005, 12:50 PM
Replies: 2
Views: 1,938
Posted By crisan
Autonumber in a query

Is there a way to compute an autoincrement number field in a query, which start to number from 1 and finnish with the last record number of query(for ex, in a query with 150.000 records...
Forum: Access April 29th, 2005, 06:18 AM
Replies: 1
Views: 13,562
Posted By crisan
Opposite to INNER JOIN query

I have to tables, tbl1 and tbl2 which of them with an ID field. I need a query which return me in qryID1 row only the ID's from tbl1 without a correspondence in tbl2 and in qryID2 row only the ID's...
Forum: Access VBA March 25th, 2005, 10:36 AM
Replies: 4
Views: 2,255
Posted By crisan
Thanks for your responses. It seems to work right...

Thanks for your responses. It seems to work right with AfterUpdate event . The idea is that I have thousands of controls which I have to enable and I use the same function from the module...
Forum: Access VBA March 25th, 2005, 07:33 AM
Replies: 4
Views: 2,255
Posted By crisan
Set focus question

I have two controls: txtQa1 and txtQa2. TxtQa2 is disabled by default and it will be enabled only if the txtQa1.value=2. I have some code on "OnExit" event of txtQa1 which will enable txtQa2 if...
Showing results 1 to 21 of 21

 


All times are GMT -4. The time now is 05:47 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.