Search:
Type: Posts; User: cubsm22p
Search:
Search took 0.02 seconds.
-
do you think that would be under property sheet > validation rule
'Like '@'
because i dont want to limit it to just that order number
-
i have a combo box that finds a record on my form based on order number i select in the drop down , is there a way i can get it to auto populate if i search part of the order number instead of the...
-
change both database data type to number then put field size to double that will make all your decimals show
-
ok i have got a form for data entry almost figured out:
158903
here is what my form looks like, i got the photo to change with the dropbox using this VBA code
Private Sub Combo75_AfterUpdate()...
-
158839
i have decided i may just want a drop down box like above picture, and have a image control linked to show up depending on what number is in the unwind field. if there is a one in the unwind...
-
how would i go about doing "image control + jpgs to shared area (or local drive) for display."
thanks for your answer
-
158763158765158767158769
I have 8 of these images , i want to make a form that has a way for for someone to select one of the images on the form to save it to a record and then later on i need the...
-
i would like to have a button to push to refresh my links to my backend and frontend access database so people entering data dont have to go to the linked table manager every time they want to update...
-
i have a button on my form that deletes a record and adds the record to another table and when it does that the form looks like this:
158507
this makes my find button 158509 search the [Order...
-
i figured out if i go to the headers and open the property sheet change the [force new page] to none for all sections
158403
-
158397 this button is linked to a report and when i click on it it is giving me a blank page at first158401 then when i click [next page] at the bottom it shows 158399 how do i get rid of the blank...
-
i changed the feild type to a double and it worked
-
how do i stop this field from rounding to a whole number
158009
goes to
158011
-
i have these date buttons i put on the form and now i have a problem with them being in the way when i click through other tabs on the form
157553
then when i switch tabs i get....157555
-
here is the code im using, it is executing with out errors but not getting any desired results
#include "stdafx.h"
#include <fstream>
#include <iostream>
#include <sstream>
#include <string>...
-
i fixed this problem by going to to property sheet for the combo box and changed limit to list to yes
-
i am writing a code to throw an error if user types in something in combobox that is not in the table. how would i compare the Combobox value with the tables feild values
here is what my guess was...
-
thank you for the advice with a little research with google i found something that worked:
Me![Combo970]= Null
-
i gave this a try and had no luck
-
i have a combo box that i made for bringing up records on a form but i wold like the combo box to be cleared after the form has been populated any ideas on how this would be done?
157119
157121
...
-
i used this code to move the record to a different table then made the report off that table,
Private Sub Command985_Click()
On Error GoTo Err_Command985_Click
DoCmd.SetWarnings False...
-
i need to link the planning worksheet to auto fill from the order master. right now i have user typing in order number but would like to somehow link the me.[order number] from the form to the report...
-
i have missed your post suggesting what i can do to handle nulls
-
i have this code that sucessfully works takes a record from one table and moves it to another, but when doing this is handling the null dates not as desired. it is putting default 12:00:00 am in in...
-
156825
got this error after using this code
DoCmd.RunSQL "Insert Into [Archive] * Values " & _
' "('me.Order_Number',#me.[Date Entered Into...
-
what should i use wih the yes/no feilds
-
here is what the text data type is in every table
156805
he is ever number data type
156807
Text data type
156809
Yes/No data type
156811
Memo data type
156813
-
ok i have no exra table and made some changes till keep getting this error
156803
Private Sub Archive_Order_Click()
On Error GoTo Err_Archive_Order_Click
Dim Answer As Integer
Dim...
-
ok i changed my code to this , and now im getting a data mismatch error in the VALUES part of the code not sure if i represented String, integer, and date right
for date i used = # " *...
-
it had a primary key of the [order number] but i recently took the primary key off every table and still am getting the same error
-
here is the error message after i click the button
156747
and here is my code, both tables have the same structure
Private Sub Archive_Order_Click()
On Error GoTo Err_Archive_Order_Click
...
-
You my friend solved the problem manipulated the field in the Duptbl after changing the criteria of that field only in that table
-
i am trying to change the date in this field to be the date and time currently
DoCmd.RunSQL "update Duptbl set [Date Entered Into Alvin] = now()"
-
i am trying to change a primary key that is the same as the previous record i duplicated and i keep getting an err.
156463
156469
156471
the ID field is an auto number field
here is the vb...
-
-
here is what i have so far
Private Sub Duplicate__Record_Click()
DoCmd.RunSQL "Delete * From Duptbl"
DoCmd.RunSQL "insert into Duptbl select * from [Order Master] where [Order Number] =...
-
hello im am trying to match up data types in a sql statement i know the date is # " * Me.Date & " # and a string would be " & Me.Customer & " ' i can not figure out what the rest would be, how would...
-
Hello guys i have a duplicate button with some SQL code embedded into it and i cannot get the sql code to execute here is a copy of the code
Private Sub Duplicate__Record_Click()
Dim fullpath As...
-
This worked now im tring to get my SQL code to run correctly
onn = [order number].Value
If onn Like "0000********" Then
onn = Format(onn + 100000000, String(12, "0"))
ElseIf onn Like...
-
this code seemed to do the trick now i have to some how use a statement to see if the first four number are 0000 or 0001 or 0002 or 0003
Dim fullpath As String
Dim dirs(0 To 2) As String
Dim s...
|
Click Here to Expand Forum to Full Width
|