|
Integer SQL Server to AutoNumber in Access
I'm trying to make a TableID and autonumber in Access. This is on a
linked table to SQL Server backend. The field is datatype integer in
SQL Server, but I can't get this field to become an autonumber in
Access. What kind of silly mistake am I making here? Thanks for any
help you can provide....
|
2 |
12/8/2008 4:30:57 PM |
|
|
Append querie error
DoCmd.RunSQL ("INSERT INTO tblProductsLog VALUES (" & [staffID] & "," &
[productID] & "," & -[productQuantity] & ",'" & Now() & "');")
staffID, productID, productQuantity are integer...
|
5 |
12/8/2008 4:17:57 PM |
|
|
Foreign Language in Menu items
Hello,
My Switchboard menu items takes the text from menutiems table.
Since I want to make the menu items according to the language of the
country. I want to insert the menu text in local as beside the the English
column. My question is how can we say in the menu text item of the form ithat
it will take the text from the local column?
The Ooher alternative is to replace the English ...
|
15 |
12/8/2008 1:00:04 PM |
|
|
changing taborder
Hi,
I want to change the tab order into a more logical one..
However, When I enter a new value, it is automatically overwritten by
the orld value....
What to do???
can't I automate the task of having to enter a number in each tab-order
field?
Thanks...
|
4 |
12/8/2008 11:28:51 AM |
|
|
Subforms
I've created a table (tblBasketsContent) and it got all basket content within
it, but i want to filter the content where basketID=1, how can i do this...
|
2 |
12/7/2008 3:56:01 PM |
|
|
how to call sub
Hope someone can remind me how to do the following.
From an after_update event of a control on a form, I'd like to call
the 'on current' sub of the same form.
richard...
|
3 |
12/7/2008 2:52:27 AM |
|
|
Specify Character Range in function parameter
Hello, I'm trying to lookup a value in a textbox on a form. It is in the
format ##a (number-number-letter) and indicates a cycle (such as 07D, 06G,
etc). I am currently using the instr function, trying the following:
varCycle = Instr(Text5,"[0-9][0-9][a-k]") which obviously does not work, as
it's looking for a literal string, not a range. Basically, I want to search
the textbox box fo...
|
5 |
12/7/2008 1:49:01 AM |
|
|
subform or hidden fields.....i'm confused???
I have a form where I collect data for Truck Tickets. The trucks
carry
a load to a site. Up until now we have one ticket (or one record) per
truck per site. Now there is a requirement to where there might be
one
truck ticket, but there could be multiple sites where the truck
drops.
I thought, if possible, to have a check box or something on my form
where the label is 'multiple site ticke...
|
5 |
12/6/2008 10:28:22 PM |
|
|
form filter
Anyone know in what form event a form filter gets applied?
Thanks
RL...
|
4 |
12/6/2008 3:05:48 PM |
|
|
Custom Collection in Form Module not working
Access 2003
I am unable to get a custom collection to work in a Form module. The code
snippets are:
Dim colBaseThemes as Collection
Set colBaseThemes = New Collection
Dim strBaseRef as String
open the recordset (it works)
With rstBaseSectionThemes
.Find strBaseRef (it works)
Do While Not .EOF
colBaseThemes.Add Item:=rstBaseSectionThemes!ThemeNo,
Key:=Cstr(intBaseTheme...
|
3 |
12/6/2008 3:04:01 PM |
|
|
Inbox issues
I have a form with a button used to open a second form. The SQL code behind
the button opens an input box for user input of an "FCSI Number". When the
user enters a valid FCSI number, the second form opens correctly. There are
two instances during which I recieve an error. The first is if the user
cancels the input box, and the second is if no value is entered for the "FCSI
number"
P...
|
4 |
12/6/2008 1:21:17 PM |
|
|
form events
can anyone tell me
1) in which event a Filter that is placed in the form property sheet
(eg- Filter = SQL statement) would take place?
2) If I use a RunCmd Recordsgotonew in an event on a form, to where
does this place the already-open form in the sequence of 'opening'
events for the form?
Thanks in advance.
R...
|
2 |
12/6/2008 11:57:36 AM |
|
|
Run Time Error 2501
I have use this code to open my report and my form using Pass to Query
but i have this error 2501 when i try to click click.
***************here is my code***************************
On Error GoTo Proc_Error
Dim rsp As String
Dim Mynote As String
Mynote = "You will be sorting data by " & _
"Site Location-Discipline-Index respectively. " & _
vbCrLf & " " ...
|
2 |
12/6/2008 4:40:00 AM |
|
|
Return to record on main form
Man, here it is 5pm on a Friday and I'm stuck!
Here's my problem. I click a button on one form, frmIntegration, to launch
a 2nd form, frmUse_Case. After I'm done editing and close frmUse_Case I want
to do two things: requery frmIntegration (which I know how to do) AND return
to the record that I was on when I left the form (which I don't know how to
do). I am opening the 2nd form by ...
|
2 |
12/6/2008 3:59:48 AM |
|
|
whats lower than or equals to if statement? <= not working :<
whats lower than or equals to if statement? <= not working :<...
|
5 |
12/6/2008 12:28:32 AM |
|
|
Form Navigation
Hello,
I have a form with a subform that contains about 55 fields. Is there a way
to programmatically
move the parent form automatically (scroll right) when user tabs to a
certian postion ?
For example, they tab over to the 17th column, as they tab over,
automatically move the form right
This is a huge complaint on a production Access app. Any suggestions or help
greatly
appreciat...
|
2 |
12/6/2008 12:03:07 AM |
|
|
Form coding help please
I am having a few form coding problems and i hope someone can help.
Basically i have the form which is used to add new customers to a table.
The first text box (accountcode) works how its supposed to in that i enter
an accountcode and it goes to the next box if the code doesnt already
exist,but it will not let you goto the next box until a code is entered.
The postcode textbox however...
|
7 |
12/5/2008 9:00:26 PM |
|
|
Opening Powerpoint File not working..
I opened a Word file with this command:
strDocName = strDirName & "\" & file_location
Set WordDoc = WordApp.Documents.Open(strDocName)
Now I'm trying to do the same with Powerpoint:
Set PowerpointDoc = PowerpointApp.Presentations.Open(strDocName)
(of course it is a powerpoint file in this case)
any helpful hints?
jokobe...
|
3 |
12/5/2008 7:28:11 PM |
|
|
More Form/SubForm Issues
Help required as usual. The Cmd button sits on a [mainform] while the
SISitemCode resides on a subform on the [mainform]. The [MainForm]
opens but is blank. I think I'm missing some path to the subForm
Private Sub cmdCloneItem_Click()
DoCmd.OpenForm "frmMaterialMasterADD", , , "[SISitemCode] = " & Chr
$(34) & SISItemCode & Chr$(34)
End Sub
Any assistance would be appreciated....
|
11 |
12/5/2008 7:06:11 PM |
|
|
engine does not recognize " as a valid field name
I have a report with the following query as its recordsource. It works fine
in Access 2003 but when I run in 2007 I get the "engine does not
recognize..." error. Can anyone help?
PARAMETERS [forms]![frmSelectTerm]![TermYear] Text ( 255 ),
[forms]![frmSelectTerm]![Term] Text ( 255 ),
[forms]![frmSelectTerm]![TermYear2] Text ( 255 ),
[forms]![frmSelectTerm]![Term2] Text ( 255 );
TRANSF...
|
6 |
12/5/2008 5:33:41 PM |
|
|
Calibri Font in Access Runtime
I'm wondering whether the Calibri font is included in the A2007 runtime
distribution. I've been searching high and low and can't find an answer to
this question. (I understand this font is included w. the pp viewer.) Thanks
-- Mike...
|
3 |
12/7/2008 12:26:00 AM |
|
|
If Then for on Form Close
I have a form that displays a MSGBox beforeupdate when specific fields are
null. If these fields haven't been touched then the form closes like normal.
After the fields have been maintain
I'd like to be able to add an If...then statement so on form close don't
display msgbox.
...
|
3 |
12/8/2008 1:46:05 AM |
|
|
apply filter action cancelled
I'm trying to use recordsgotonew command on an open order-entry type
of form/subform so that I can thus enter new record. There is a
filter applied to the form after update of one of the form controls.
After entry of data for first client, which proceeds without a
problem, I then click a 'next' cmdbtn which has the recordsgotonew
command entered, and the data on the form clears appropriatel...
|
3 |
12/8/2008 2:23:52 PM |
|
|
Populate Combo Boxes using Form_Current Options
I've got 3 unbound combo boxes on my form that are used to narrow
down
and find results in a couple of tables that are used in an Insert
Process. The combo boxes work as expected except when cycling through
records they do not show the values that should be associated. I've
tried using the Form_Current function in order to populate the values
when the record in shown, but for some reason it ...
|
4 |
12/8/2008 2:40:23 PM |
|
|
command button 2007
Brand new with access-
How can I create a command in datasheet form to open another form? Is this
possible? I tried doing the command in datasheet view/form but it didn't work.
I'd like to create a command next to each person's name. So if I clicked on
their last name in datasheet view-it'd open to a new form with lots more
detail.
Step by step instrucitons please!
--
Message posted ...
|
4 |
12/5/2008 8:08:30 PM |