Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 73
Search took 0.05 seconds.
Search: Posts Made By: Coldsteel
Forum: Forms 09-18-2012, 07:57 AM
Replies: 9
Views: 1,772
Posted By Coldsteel
Re: Unbound form to update continuous form fields

I made the following update query with the following sql statement, is this the most efficient way?

UPDATE Inv SET Inv.Area = [Forms]![Hostveiw]![txtupdate]
WHERE...
Forum: Forms 09-18-2012, 07:40 AM
Replies: 9
Views: 1,772
Posted By Coldsteel
Re: Unbound form to update continuous form fields

Thanks for the help,

The selection is made from the form Main, you click on the hosting field and it opens the continuous form (Hostveiw) with the matching hosting name , and it is that selection...
Forum: Forms 09-17-2012, 07:18 PM
Replies: 9
Views: 1,772
Posted By Coldsteel
Forum: Forms 09-17-2012, 07:13 PM
Replies: 9
Views: 1,772
Posted By Coldsteel
Unbound form to update continuous form fields

Hello,

I am trying to update a continuous form with multiple records with a unbound text box. I have tried the following on click event and I am only updating one record on the continuous form....
Forum: Queries 09-08-2012, 12:29 PM
Replies: 17
Views: 5,418
Posted By Coldsteel
Re: Record set is not updatable

Thanks,
That's a great idea, I just built a form and subform, is there a way to make it in data sheet format as a continuous line
Forum: Queries 09-08-2012, 11:05 AM
Replies: 17
Views: 5,418
Posted By Coldsteel
Re: Record set is not updatable

Thanks for the help,

Basically, I want to import the data to a tbl called Lease and then compare it to the Inv table by serial numbers and be able to edit both on the query.

Table Lease will...
Forum: Tables 09-07-2012, 07:21 AM
Replies: 1
Views: 538
Posted By Coldsteel
Table Relationships

Hello All

I have a question. I currently am using Access 2007.

Basically I have a excel report I receive from another dept with incomplete data. I import the excel to a table I call Lease.
...
Forum: Queries 09-06-2012, 04:10 AM
Replies: 17
Views: 5,418
Posted By Coldsteel
Re: Record set is not updatable

I have tried the different ways to create the table relationships but I not had any success allowing the query to be updated is there a bypass feature in access?
Forum: Queries 09-05-2012, 08:16 PM
Replies: 17
Views: 5,418
Posted By Coldsteel
Re: Record set is not updatable

Thanks, for the help and the references.
I have been studying them, and I have a question. Basically I have a excel report I receive from another dept with incomplete data the table I call Lease. ...
Forum: Queries 09-03-2012, 08:15 PM
Replies: 17
Views: 5,418
Posted By Coldsteel
Re: Record set is not updatable

Thanks, for the help. Here is some more data.
Forum: Queries 09-02-2012, 11:19 AM
Replies: 17
Views: 5,418
Posted By Coldsteel
Re: Record set is not updatable

I have tried to looking on my properties settings but I have not yet found the cause of why access won't let me update my records
Forum: Queries 08-31-2012, 11:24 PM
Replies: 17
Views: 5,418
Posted By Coldsteel
Forum: Queries 08-31-2012, 11:20 PM
Replies: 17
Views: 5,418
Posted By Coldsteel
Re: Record set is not updatable

Thanks for the help, Here is my database
Forum: Queries 08-30-2012, 08:12 PM
Replies: 17
Views: 5,418
Posted By Coldsteel
Record set is not updatable

Hello,

I am trying to edit my query and keep getting the error Record set is not updatable. Is any one able to assist me with this issue

Here is my sql

SELECT Inv.[ID], Inv.[Area],...
Forum: Queries 08-01-2012, 05:40 AM
Replies: 4
Views: 988
Posted By Coldsteel
Re: Adding more fields to a Union Query

Thanks so much, this helps me greatly
Forum: Queries 08-01-2012, 04:19 AM
Replies: 4
Views: 988
Posted By Coldsteel
Re: Adding more fields to a Union Query

Thanks for the reply, The data does display as

Serial
1
2
3
4
5
6
7
Forum: Queries 07-31-2012, 09:05 PM
Replies: 4
Views: 988
Posted By Coldsteel
Adding more fields to a Union Query

Hello all,

I have a question I have table with the following fields listed below

Inv ()
ID Area Hosting Pc_SN Montior_SN Montior3_SN
1 Houston d13 ...
Forum: Modules & VBA 11-30-2011, 04:55 PM
Replies: 6
Views: 1,289
Posted By Coldsteel
Re: Access can't find the 'FrmLookup' referred to in your expression in a form

I tried the exact same code but, I used a Table for instead of a Query as the subforms' record source and it works, but is there a way for me to use a Query instead?
Forum: Modules & VBA 11-30-2011, 03:38 PM
Replies: 6
Views: 1,289
Posted By Coldsteel
Re: Access can't find the 'FrmLookup' referred to in your expression in a form

Thanks again for the help, I set the footer to visible, and I tried the long way to name my sub-form (Forms![form name]![control name].Form.[control name]), but I still get the same error.
Forum: Modules & VBA 11-30-2011, 02:26 PM
Replies: 6
Views: 1,289
Posted By Coldsteel
Re: Access can't find the 'FrmLookup' referred to in your expression in a form

Thanks for the help,
FrmLookup is the name of the subformcontrol. I am not to sure what you mean, can you provide me a example.

Thanks
Forum: Modules & VBA 11-30-2011, 01:38 PM
Replies: 6
Views: 1,289
Posted By Coldsteel
Access can't find the 'FrmLookup' referred to in your expression in a form

Hello all,
I keeping a the error (Access can't find the 'FrmSearch' referred to in your expression in a form) Can anyone point me in the right direction. Here is my code:

Private Sub...
Forum: Excel 05-04-2010, 09:12 AM
Replies: 1
Views: 2,739
Posted By Coldsteel
Pivot Tables keep ungrouping when I Refresh

Hello,

I am using Excel 2007 and I have about 20 pivot tables on my sheet. I am using a Microsoft Query to get me the data I need form a Access Database. But, everytime I refresh the date...
Forum: Modules & VBA 03-30-2010, 10:58 PM
Replies: 3
Views: 747
Posted By Coldsteel
Re: Using SQL with RecordSet

Thanks for the help Wayne. I have been working on this Sql Statement to see if what i am processing is correct. I keep getting errors. Here is the code i have been playing with to see my SQL...
Forum: Modules & VBA 03-30-2010, 08:22 PM
Replies: 3
Views: 747
Posted By Coldsteel
Using SQL with RecordSet

I keep getting the run-time error 3709 when I run this code. Can someone help me figure out what I am doing wrong.

Private Sub Text114_Click()

Dim ar As adodb.Recordset

Set ar...
Forum: General 03-30-2010, 07:26 PM
Replies: 4
Views: 965
Posted By Coldsteel
Re: Having problems with Dlookup

Thanks for the help, I have been working on converting my dlookups to SQL, but I am new to using record sets. Here is some of my SQL. Will you point me in the right direction in converting this to...
Showing results 1 to 25 of 73

 
Forum Jump



All times are GMT -8. The time now is 07:22 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World