Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 116
Search took 0.05 seconds.
Search: Posts Made By: rborob
Forum: Forms 01-29-2007, 01:14 AM
Replies: 6
Views: 937
Posted By rborob
Round(f.Text138, 2)

Round(f.Text138, 2)
Forum: Forms 01-26-2007, 08:23 AM
Replies: 7
Views: 1,206
Posted By rborob
yeah..that too

yeah..that too
Forum: Forms 01-26-2007, 08:21 AM
Replies: 7
Views: 1,206
Posted By rborob
put single quotes around strings? outside of the...

put single quotes around strings? outside of the double quotes?
Forum: Forms 01-26-2007, 01:58 AM
Replies: 4
Views: 2,329
Posted By rborob
is it just the number yout need to increment? ...

is it just the number yout need to increment?

say you had 15 rows in the table, you'd want the textbox to show 16?

why not use =Count+1

i suppose you could open a recordset and loop through...
Forum: Forms 01-26-2007, 01:52 AM
Replies: 6
Views: 1,269
Posted By rborob
or just have a loop on the splash screen to see...

or just have a loop on the splash screen to see if the form has loaded
Forum: Forms 01-26-2007, 01:51 AM
Replies: 3
Views: 538
Posted By rborob
your putting the text onto another form? then...

your putting the text onto another form? then use

Forms!"yourformname"!"destinationtextbox" = Me.txtArea
Forum: Forms 01-25-2007, 08:49 AM
Replies: 4
Views: 926
Posted By rborob
hmm..how do you intend to save it? inline SQL? a...

hmm..how do you intend to save it? inline SQL? a query? setting the name to a text box?
On the After_Update of the combo box put

Me.txtbox = Me.combobox.column(0)

that will assign the name...
Forum: Forms 01-25-2007, 08:47 AM
Replies: 4
Views: 2,329
Posted By rborob
cant you use a recordset to find the number of...

cant you use a recordset to find the number of records in a table using Count()
then increment this value. alternatively use a combo box that has a MAX statement as a row source then just reference...
Forum: Forms 01-25-2007, 08:42 AM
Replies: 7
Views: 1,331
Posted By rborob
every time i post on here someone always says...

every time i post on here someone always says something better :P
Forum: Forms 01-25-2007, 08:34 AM
Replies: 10
Views: 923
Posted By rborob
debug is where you insert breakpoints in your...

debug is where you insert breakpoints in your code to "step" through it and find what is going on behind the scenes. That way you can see how the code is executed and if it doing what you want it to...
Forum: Forms 01-25-2007, 08:33 AM
Replies: 7
Views: 1,331
Posted By rborob
if the sub form is bound you wont be able to...

if the sub form is bound you wont be able to assign any values to the fields in it,,,i dont think. Cant you use the OpenArgs to pass in the ID?

DoCmd.OpenForm stDocName, , , , , ,...
Forum: Reports 01-25-2007, 08:31 AM
Replies: 9
Views: 1,222
Posted By rborob
ill assume that the report is bound to a table?...

ill assume that the report is bound to a table? and the checkboxes are based on yes/no fields?
(big assumption i know)

then a select statement would give you the number of checked boxes

e.g. ...
Forum: Forms 01-25-2007, 08:22 AM
Replies: 10
Views: 923
Posted By rborob
have you debugged it to see what its doing wrong?...

have you debugged it to see what its doing wrong? where is it breaking? is it looping at all?
Forum: Forms 01-25-2007, 08:18 AM
Replies: 8
Views: 1,016
Posted By rborob
im still stuck on this. I tried setting the...

im still stuck on this. I tried setting the focus to another textbox then on the focus of that moving it away to my target text box..to no avail. :(
Forum: Forms 01-25-2007, 08:16 AM
Replies: 6
Views: 983
Posted By rborob
works though

works though
Forum: Forms 01-25-2007, 08:08 AM
Replies: 6
Views: 983
Posted By rborob
if i remember correctly u were using 16775639 ...

if i remember correctly u were using
16775639
as the color code?

.BackColor = "16775639"

works fine for me...horrible color though :P
Forum: Forms 01-25-2007, 07:50 AM
Replies: 4
Views: 926
Posted By rborob
use combo.column(0) for the first...

use

combo.column(0)

for the first column in a combo box to return its value
Forum: Forms 01-25-2007, 07:47 AM
Replies: 6
Views: 983
Posted By rborob
i answered you yesterday after "creating some...

i answered you yesterday after "creating some code" for you to change the background. If the color is one you created and put manually into the pallate then it may not register on his PC but im...
Forum: Forms 01-25-2007, 07:44 AM
Replies: 12
Views: 1,739
Posted By rborob
havent had a proper look but ive added a bit to...

havent had a proper look but ive added a bit to your "temp" Sub to show you how i would do it. Also changed the rowsource of your combo box to return the table names. have a look at the code. This...
Forum: Forms 01-25-2007, 07:11 AM
Replies: 7
Views: 2,389
Posted By rborob
use .Text instead of value

use .Text instead of value
Forum: Forms 01-25-2007, 01:20 AM
Replies: 12
Views: 1,143
Posted By rborob
i take it your form is bound to the table? and...

i take it your form is bound to the table? and its saying you cant edit it?
Forum: Forms 01-25-2007, 01:17 AM
Replies: 3
Views: 538
Posted By rborob
Depending on the box clicked i assume you'll be...

Depending on the box clicked i assume you'll be having a button next to every picture? if this is the case you just need to assign An Area name to each button then assign it to the Area field in the...
Forum: Forms 01-25-2007, 01:15 AM
Replies: 2
Views: 677
Posted By rborob
wanna tell us what the links on the tables are? i...

wanna tell us what the links on the tables are? i only see one
Forum: Forms 01-25-2007, 01:08 AM
Replies: 8
Views: 1,016
Posted By rborob
anyone know of a solution to this?...please?

anyone know of a solution to this?...please?
Forum: Forms 01-25-2007, 01:07 AM
Replies: 12
Views: 1,739
Posted By rborob
Have a function Called SQLCreator or something....

Have a function Called SQLCreator or something. then in that have your SQL being built as i mentioned above. Have all the criteria (i cant tell what your criteria is really since your field names...
Showing results 1 to 25 of 116

 
Forum Jump



All times are GMT -8. The time now is 06:45 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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World