Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
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 25 of 34
Search took 0.01 seconds.
Search: Posts Made By: hewstone999
Forum: Access VBA June 16th, 2008, 05:24 AM
Replies: 1
SQL
Views: 868
Posted By hewstone999
SQL

I have this update SQL query(See below). Tho it keep saying "Operation must use an updateable query". Any ideas on wats wrong with the code? Thanks


UPDATE TEST_DOC SET TEST_DOC.DataSet = (Select...
Forum: Access VBA June 12th, 2008, 04:00 AM
Replies: 1
Views: 1,421
Posted By hewstone999
SORTING an table

I currently have this data in the "tbl_Infor" Tbale

Tlb_name RowNo Comments
----------------------------------------
MPI 1 Username
MPI 2 Forename
MPI...
Forum: Access VBA June 3rd, 2008, 05:16 AM
Replies: 2
Views: 1,568
Posted By hewstone999
Add a button to a cell

I want to add a buttom to Cell D1 using VBA....

I already have the code to create a button, i just need the code to move the button to the required cell.

ANy help or ideas?
Forum: Access VBA May 28th, 2008, 05:26 AM
Replies: 0
Views: 785
Posted By hewstone999
Access and Excel help

I’m currently using vba in access to export values to an Excel Spreadsheet. I have this query below but I cant seem to export the value the SQL statement gives to the correct field in the...
Forum: Access VBA April 23rd, 2008, 05:11 AM
Replies: 2
Views: 1,204
Posted By hewstone999
Removing duplicates

I have two tables: “tmptable” and “CC_CODES”

Both tables contain the same data; however the “tmptable” contains updated data. How can I compare both tables and remove all the duplicate...
Forum: Access VBA April 15th, 2008, 08:32 AM
Replies: 1
Views: 946
Posted By hewstone999
Changing a string?

I have the following code:

a = "03-Patients-Data"

How can i change the "03-Patients-Data" - to - "03_Patients_Data"
Forum: Access VBA April 15th, 2008, 07:37 AM
Replies: 1
Views: 1,060
Posted By hewstone999
How do you get Rid of quotes

I have this following code:

---------------------------------------------------------
a = "MPI_CORE_DATA"

b = 'Need something here to get rid of the quotes in a

DoCmd.RunSQL...
Forum: Access VBA March 25th, 2008, 11:22 AM
Replies: 0
Views: 939
Posted By hewstone999
Interacting with Word

I have this code (Access VBA) at the moment that uses Bookmarks to insert information into a word doc.



Code:

Private Sub Command0_Click()
Dim Wrd As Object
Set Wrd =...
Forum: Access VBA March 20th, 2008, 06:28 AM
Replies: 0
Views: 850
Posted By hewstone999
Export a Table into Word

I have a table called "MPI_CODE" it has 4 columns. How can I export this to Word? By creating a new document first (Using Save dialog) then exporting that table to the word doc. Mainly looking for...
Forum: Access VBA March 18th, 2008, 06:08 AM
Replies: 0
Views: 1,728
Posted By hewstone999
Add a button with code into Excel

I have an export function in Access that exports data into Excel. From Access i want to create a button in Excel and add some code to that button.

Any ideas or help or nay code i could use, thanks.
Forum: Access VBA March 18th, 2008, 05:34 AM
Replies: 1
Views: 6,942
Posted By hewstone999
Get last record and display in an Text Box

I have a Text Box called: VNo , and a table called: DocControl.

The Table contains this information

Name.............Version.............Date
-------------------------------------------
GFD ...
Forum: Access VBA March 18th, 2008, 05:23 AM
Replies: 5
Views: 1,506
Posted By hewstone999
Yes thank you. I changed the code a little to...

Yes thank you. I changed the code a little to suit my purpose but the general idea was good.

Thank you :D
Forum: Access VBA March 17th, 2008, 06:47 AM
Replies: 5
Views: 1,506
Posted By hewstone999
'get value in table sorry i meant 'next...

'get value in table
sorry i meant
'next value in table
Forum: Access VBA March 17th, 2008, 06:45 AM
Replies: 5
Views: 1,506
Posted By hewstone999
What i would like is something like this: ...

What i would like is something like this:

Start loop

TblValue = ExportTables.Value
DoCmd.RunSQL "INSERT INTO TEST_DOC SELECT * FROM " & TblValue

'get value in table

End loop
Forum: Access VBA March 17th, 2008, 05:14 AM
Replies: 5
Views: 1,506
Posted By hewstone999
Loop through a Table and return the value

Loop through a Table and return the value


I have a table (ExportTables) with the following data

ExportTables
--------------------
MPI_CODE
MPI_IDS
MPI_REFF
Forum: Access VBA March 14th, 2008, 06:38 AM
Replies: 1
Views: 3,157
Posted By hewstone999
Create Check Boxes/Option buttons/Option Group

I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA.

Could someone help on either all of them or some of them please?

Thanks

Richard
Forum: Access VBA March 13th, 2008, 07:35 AM
Replies: 1
Views: 1,331
Posted By hewstone999
Check boxes to appear with Table Names

What I want is check boxes to appear on a form with the name of the tables.

i.e. I Currently have 3 tables (there are more tables in my database but for this example I will only use 3) - ...
Forum: Access VBA March 11th, 2008, 07:04 AM
Replies: 3
Views: 1,143
Posted By hewstone999
Yes it works :) How could i get a time value...

Yes it works :)

How could i get a time value from this aswell as the file also gets updated every 3 hours, thanks
Forum: Access VBA March 11th, 2008, 06:11 AM
Replies: 3
Views: 1,143
Posted By hewstone999
Formatting Problem

The code below imports the file Modified Time and Date into a table. However the value in the table = '39491.4423611111' , it should be: 13-Feb-2008 10:37:00. I've tried changing the data types to...
Forum: Access VBA March 10th, 2008, 07:13 AM
Replies: 4
Views: 1,349
Posted By hewstone999
OK thanks for your help but im new to...

OK thanks for your help but im new to programming, what will i have to put for:

"MyLocalTableWithSpreadSheetNamesAndAttributes"
Forum: Access VBA March 10th, 2008, 06:01 AM
Replies: 4
Views: 1,349
Posted By hewstone999
Check for updated files

When I open a form, I want it to automatically check to see if there is are any updated files. I already have imported files into Access, but want to automatically check to see weather there have...
Forum: Access VBA March 10th, 2008, 04:22 AM
Replies: 1
Views: 12,056
Posted By hewstone999
Get rid of the "Update Messages"

I have a button that inserts values into a table. But every time is dose this, a update message appears. How can i change this so this doesn’t appear? Is it something to do with the security...
Forum: Access VBA March 7th, 2008, 07:19 AM
Replies: 0
Views: 2,090
Posted By hewstone999
Change the format of MS Excel Cells from MS Access

Dim strExcelFile As String
Dim strWorksheet As String
Dim strDB As String
Dim strTable As String
Dim objDB As Database

strExcelFile = "E:\CSC\LDMS\LDMSDatabaseApp\LDMS_Spec.xls"
strWorksheet...
Forum: Access VBA March 7th, 2008, 06:17 AM
Replies: 1
Views: 2,334
Posted By hewstone999
Create an Excel Spread with multiple worksheets

I have a button that when I click on it, I want it to create an Excel Spreadsheet with 5 worksheets.

Also how can I change the cell formats in Excel from Access? i.e. I have an export function in...
Forum: Access VBA March 6th, 2008, 07:04 AM
Replies: 1
Views: 1,158
Posted By hewstone999
Importing into Access

I import data from a Spreadsheet into an Access Table. When I import the data I also want to populate one column with name of the Access Table. i.e. i’ve got a table called: MPI_IDS_IFFs so I want...
Showing results 1 to 25 of 34

 


All times are GMT -4. The time now is 06:31 PM.


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