Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 68
Search took 0.01 seconds.
Search: Posts Made By: Brian Martin
Forum: General 02-11-2005, 06:25 AM
Replies: 2
Views: 722
Posted By Brian Martin
Thankyou!!!

Fantastic!! I've spent all morning trying to work that out. You've made my day and helped set me up for a good weekend. Thankyou!!
Forum: General 02-11-2005, 04:35 AM
Replies: 2
Views: 722
Posted By Brian Martin
Question reference combo box value

I want the full description text box to pickup the value from cboPress. I don't want the user to have to click on it though. I have tried using the selected property but couldn't quite get it to...
Forum: Modules & VBA 03-10-2004, 03:44 AM
Replies: 8
Views: 741
Posted By Brian Martin
Getting there

It is a memo. I have partly sorted the problem. i had set the format of the memo field as > to make all the text capitals. i deleted that and now it lets me input more than 255. But when I run an...
Forum: Modules & VBA 03-10-2004, 03:17 AM
Replies: 8
Views: 741
Posted By Brian Martin
No luck

tried your code and it didn't work either. I'm stumped. the reason I'm trying to do this instead of a regular query is because I have a memo field that just wont allow anything greater than 255...
Forum: Modules & VBA 03-10-2004, 02:10 AM
Replies: 8
Views: 741
Posted By Brian Martin
Still stuck

Both fields are text fields.
i now have the following and it still doesn't work.

SQLstring = "UPDATE [Product List] SET [Full Description] =" &...
Forum: Modules & VBA 03-09-2004, 08:20 AM
Replies: 8
Views: 741
Posted By Brian Martin
Update problem

Nothing is being updated What is wrong with this code?:
SQLstring = "UPDATE [Product List] SET [Full Description] =" & [Forms]![frmChoose]![subChoose].[Form].Controls![FD] & "WHERE [Part Number] ="...
Forum: General 03-09-2004, 12:46 AM
Replies: 3
Views: 531
Posted By Brian Martin
Thankyou for all your suggestions but I have...

Thankyou for all your suggestions but I have fixed the problem although I don't know why it was a problem. The queries activated by clicking the button used data from two textboxes on the form. I...
Forum: General 03-08-2004, 01:47 AM
Replies: 3
Views: 531
Posted By Brian Martin
Question Different PC different result

I have created a button on one of the forms in my database that works perfectly on my computer under my admin login. It also works perfectly on my computer under other users logins. But if I try on...
Forum: General 09-26-2003, 03:38 AM
Replies: 4
Views: 711
Posted By Brian Martin
Yeah sorry! Was in a bit of a panic!

Yeah sorry! Was in a bit of a panic!
Forum: General 09-26-2003, 01:23 AM
Replies: 2
Views: 896
Posted By Brian Martin
Restore database. Serious

I want to restore my secure databse from yesterdays back up tape. Can I simply overwrite the mdb file with yesterdays keeping the same name. Will the secured mdw file still be able to open it. Or...
Forum: General 09-26-2003, 12:03 AM
Replies: 4
Views: 711
Posted By Brian Martin
Help Help Help Help

I've just accidentally deleted records from a table in my database because I didn'r realise the tables were linked. How can I restore this data. Aaaaaargh
Forum: General 09-18-2003, 06:00 AM
Replies: 2
Views: 644
Posted By Brian Martin
no it's definitely only taking the 255 characters.

no it's definitely only taking the 255 characters.
Forum: General 09-18-2003, 05:12 AM
Replies: 2
Views: 644
Posted By Brian Martin
Memo size

I have a field in my table which is a memo type field. However it only holds 255 characters. Why is this? It may have been a text field before I changed it to a memo I cant quite remember. Would...
Forum: Forms 09-16-2003, 05:45 AM
Replies: 0
Views: 624
Posted By Brian Martin
Form Style

Does anyone know of any web sites where you can download good looking form templates??
Forum: General 07-04-2003, 12:22 AM
Replies: 1
Views: 588
Posted By Brian Martin
Permissions

I have a secured database in which I am the administrator and I have all necessary permissions. But when I try to link to tables in this database from another secure database it says I don't have...
Forum: General 07-01-2003, 06:44 AM
Replies: 3
Views: 575
Posted By Brian Martin
Definitely pointing to the right workgroup file. ...

Definitely pointing to the right workgroup file. Everyone is using Access 2002 and the database isn't split. The Office XP which is installed in the system isn't a registered copy and everyone...
Forum: General 07-01-2003, 06:11 AM
Replies: 3
Views: 575
Posted By Brian Martin
New User Problems

I have a secure database which is currently used by 5 computers on the network. A new computer has just been added to the network but I cant seem to get into the database from it. The User Name and...
Forum: Forms 05-02-2003, 01:21 AM
Replies: 6
Views: 970
Posted By Brian Martin
Thanks

Easy once u know how!! Thanks IMO
Forum: Forms 05-02-2003, 01:03 AM
Replies: 6
Views: 970
Posted By Brian Martin
I'm trying to do something with conditional...

I'm trying to do something with conditional formatting. Im a bit puzzled how I can format the Part Number text box based on the value of the Urgent check box???
Forum: Forms 05-02-2003, 12:34 AM
Replies: 6
Views: 970
Posted By Brian Martin
Highlight records on continuous forms

I have a continuous form. If a records urgent field is ticked true then I want that record to be displayed in red text. I want to keep the continuous form. How can I do this??
Forum: General 04-28-2003, 11:31 PM
Replies: 27
Views: 2,099
Posted By Brian Martin
Thanks IMO!!!

By the Way! Thankyou for your help IMO. It was the most helpful reply i've ever had on these forums!
Forum: General 04-25-2003, 02:58 AM
Replies: 2
Views: 565
Posted By Brian Martin
too few parameters

My Query:

PARAMETERS [Forms]![CurrentList]![ListID] Text ( 255 );
SELECT Join.*, Join.ListID
FROM [Join]
WHERE (((Join.ListID)=[Forms]![CurrentList]![ListID]));

I then want to make T a...
Forum: General 04-14-2003, 01:19 AM
Replies: 27
Views: 2,099
Posted By Brian Martin
Automatically generated number

Each time a user enters a new record I want to automatically generate the next consecutive number. I want the format to be -
T-0001.......T-9999. What is the best way of doing this?
Forum: General 04-03-2003, 01:09 AM
Replies: 1
Views: 417
Posted By Brian Martin
97 and 2002 sharing

I have created a database in access 2002. Some people in the office who want to use the database have acces 97. How can I allow for 97 and 2002 users to use the same database??
Forum: Reports 03-06-2003, 03:36 AM
Replies: 1
Views: 522
Posted By Brian Martin
DLookup

I'm the following function in the control source of a textbox on my report:

=DLookUp("Specs","tblAssys","ListID = [Forms]![CurrentList]![ListID]")

I am trying to display Specs from table...
Showing results 1 to 25 of 68

 
Forum Jump



All times are GMT -8. The time now is 11:26 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