ASP.NET, SQL Server, WPF, C#, VB.NET

Hi, 
 
I am trying to set up a vending data entry form with a cmdbutton grid from A1 
 
to D10, with two fields below for data input for product sold ( 
 
[txtProductSold]), and product expired ([ProductExpired]).    IE:  You click 
 
on button A1, then enter a number for product sold in [txtProductSold], and a 
 
number for product found to be expired. 
 
What I don't want is for the data to be recorded into the accompanying table 
 
(tblProductSold) until information is entered in both fields. ...

How do i disable design view on a form to prevent users from of course 
 
redsigning it .... can i do this progmatically .... ???

How do I programmatically reference a subform? 
 
This does NOT work: 
 
Public Sub CompareStrings(FormName As String, FormField As String) 
 
Dim ThisForm As SubForm 
 
Set ThisForm = Forms.(FormName) 
 
I get an error message: 
 
Microsoft Office Access can't find the form 'My Form Name' referred to in a 
 
macro expression or Visual Basic Code. 
 
Thanks for your help, 
 
Kan

How do i hide a form instead of minimizing ... 
 
I built a log-in form where in after encoding the necessary credentials ... 
 
Assuming that the credentials are right ... the form would hide instead of 
 
close ... how do write a code for this .... I tried the docmd.runcommand 
 
runmacro windowhide but it doesn't work...

Have an existing Db that I want to run a execute the search query based on 
 
user input that represents the various fields in the DB.  Additionally return 
 
those records in a specified order in a sub form that can be printed and or 
 
exported. 
 
PLEASE HELP!! 
 
-- 
 
Kristy :)

I have a subform which displays data from a main table. In this table I have 
 
a code-generated index field (well, technically it's done with update 
 
queries) which the database updates with certain tags, depending on what part 
 
of the process the data has been run through. (There are eight different flow 
 
processes for the incoming data to run through, depending on certain 
 
criteria, and some of the data goes through more than one flow process, so 
 
the LAST tag is the most important. ...

I have the following code to open a form, which works fine.  I need to add 
 
the option to leave the model blank and return all models with the selected 
 
part number.  Can someone help me add this code?  Thanks. 
 
stLinkCriteria = "[New Part Name]=" & "'" & Me![SearchName] & "'" 
 
stLinkCriteria = stLinkCriteria & "AND [Model#]=" & "'" & Me![Model] & "'" 
 
DoCmd.OpenForm stDocName, , , stLinkCriteria

In Access 2003, on a form, I can change properties during runtime for 
 
controls using VBA (for example... changing the backcolor of a label if it's 
 
been clicked), but I would like to update the color permanently using code 
 
during runtime so that the next time I call the form, the label is now the 
 
new color.  Please help!  Thanks....

Hi there, 
 
I am in need of some assistance. 
 
I will try my best to describe my situation, if you have any questions 
 
please do not hesitate to ask. 
 
Alright, I have a table like this: 
 
Table name:tblMIX 
 
SONG_ID                                           WEEK_ID 
 
3 Doors Down Away From The Sun            19 
 
3 Doors Down Away From The Sun            22 
 
3 Doors Down Away From The Sun            23 
 
3 Doors Down Away From The Sun            25 
 
3 Doors Down Away From The Sun  ...

Can anyone help me with the coding to append records of a certain date to the 
 
Outlook Calendar? I'm able to send one record at a time by using a cmd 
 
button. But I would like Access to check all records in a specified table 
 
when the form opens and then append any that match the date criteria. 
 
I have looked at several posts and looked at some coding but can't figure it 
 
out. Can anyone get me started?

There is a form ORDER wich works with table TORDER 
 
One of its text box is NAME 
 
I need insert the NAME's data in the table TPERSONAL (other table) , in the 
 
field NAMEPER 
 
How can I insert a record in that table ? 
 
Thanks in advance 
 
CM 
 
-- 
 
Message posted via AccessMonster.com 
 
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200607/1

I Have an update query that is updateing one table called MenuInfo...the 
 
problem is that part of the criteria is based on a second table 
 
MenuDetails.  The two tables are joined on MenuID...the problem is that 
 
it's not increasing the ModGroupLevel1 field by 1. 
 
Dim LevelUpSQL As String 
 
DoCmd.SetWarnings False 
 
LevelUpSQL = "UPDATE MenuInfo LEFT JOIN MenuInfo ON MenuDetails.MenuID = 
 
MenuInfo.MenuID SET MenuInfo.ModGroupLevel1 = MenuInfo.ModGroupLevel1 + 
 
1 " & _ 
 
"WHERE (((M ...

I Have an update query that is updateing one table called MenuInfo...the 
 
problem is that part of the criteria is based on a second table 
 
MenuDetails.  The two tables are joined on MenuID...the problem is that 
 
it's not increasing the ModGroupLevel1 field by 1. 
 
Dim LevelUpSQL As String 
 
DoCmd.SetWarnings False 
 
LevelUpSQL = "UPDATE MenuDetails LEFT JOIN MenuInfo ON 
 
MenuDetails.MenuID = MenuInfo.MenuID SET MenuInfo.ModGroupLevel1 = 
 
MenuInfo.ModGroupLevel1 + 1 " & _ 
 
"WHERE ( ...

In a form named PRODUCTION  there are 3 text box for invoice data: xtype, 
 
xserie, xnumber 
 
I need valid this data from the INVOICE table, where its key is a compound 
 
key (TPINV+SERINV+NUMINV) 
 
I tried with 
 
Private Sub xnumber_AfterUpdate() 
 
Dim searchinv as string 
 
searchinv=Dlookup("*","[Invoice]", [tpinv]="& Forms![production].[xtype] and 
 
[xserie]= &Forms![production].[xnumber] and "&Forms![xnumber] 
 
If searchinv ="" then 
 
MsgBox ("Invoice doesn't exist'") 
 
Cancel = T ...

http://groups.google.com/group/microsoft.public.access.formscoding/browse_thread/thread/cdba819bdfb93a0e/6e21f23f15a47fde?lnk=st&q=*+does+access+store+custom+menu+data+group%3A*access*&rnum=4&hl=en#6e21f23f15a47fde 
 
I just found the thread above thread and wanted to add, but it has been 
 
closed. However, I noticed that the issue was never resolved. 
 
I am experiencing the same problem with menus disappearing in Access 
 
2000. I develop applications on Access 2003, but still using the Acces ...

In my Access 2000 application I have many dim statments throughout the code 
 
to define a variable called "RS" which is a DAO recordset object. 
 
However, anytime I try to dim it as such, the "set RS = 
 
currentdb.openrecordset(strSQL)" command fails. So, I have resorted to 
 
dimming it as an object and that works just fine... i.e.. 
 
"dim RS as Object" INSTEAD OF "dim RS as DAO.Recordset" 
 
Is there any problme with doing this? Will I be incurring additional 
 
overhead as now it has to f ...

OK, here's the long story: 
 
I'm writing a Project Management application that I want to integrate with 
 
Primavera.  I want to be able to import Primavera data, save it into a table 
 
in my database, allow users to work with it there, and then export it again 
 
to Primavera.  To do this, the Primavera file must be saved in DBF format, 
 
which is no big problem, because Primavera can do that automatically. 
 
The problem is, I don't want users to have to tell the application which 
 
table  ...

I have an update query that combines the data of 4 fields from the current 
 
table into one when the form is closed. Right now it runs an update on every 
 
record in the table.  What is the criteria I can use to update only the 
 
current record displayed in the form??

I've read a few previous posts but none have really given me the answer 
 
I was looking for (I'm also very new to access).  I am creating a form 
 
generator that would allow users to select multiple clauses (they vary 
 
in length from 25 to over 255 characters) from a list to be output to a 
 
report.  I would like to create a form that allows the user to view the 
 
complete listing of clauses and simply highlight which ones they need. 
 
I also would like to give the user the ability to cre ...

Hello, i have a form that pulls current open projects from each selected 
 
users by using these three criterias: 
 
- user name 
 
- fiscal year 
 
- quarter 
 
Each of these are combo boxes and are cascading lists, dependant on the 
 
field before it. 
 
What i want to do is: 
 
Have a 4th field titled "projects" be a list box that pulls all projects 
 
that matches the three criterias selected above.  I have some coding for this 
 
already, but keep getting an error that says something along  ...

Hi.. I was able to make a log in screen with corresponding codes  ...... 
 
I also included (if right) lnguserno = me.combo0.value .... which is suppose 
 
to store publicly? the userno.   .... How do i make use of this value to be 
 
filter criteria for all other forms that would be opened. I want all the 
 
succeeding forms be filtered based on the lnguserno variable. 
 
Is there any example on this that I can refer to? 
 
Thanks. Hoping for your fast response. 
 
Option Compare Database 
 
Op ...

I would like to open an Access database from another access database form 
 
and set the workgroup file for the new database. 
 
I have tried to open a  shortcut file from the code of the form but not sure 
 
how to do it correctly. 
 
I have also tried using the shell command and the command line equivalent to 
 
opening the databse with the correct workgroup. It seems to work OK except 
 
when there are spaces in the path name folders or in the database file name. 
 
Can any one help me with t ...

I have A form with multiple critea being sent to a query.  What i am trying 
 
to do is save those recods in a record set  to feelin in text boxes on a 
 
secound form allowing check boxes to futher limit and then send that 
 
information to a third page to allow editing.  and finally to a tabel to be 
 
saved till later.  My problem is my record set is giveing me several 
 
exceptions and my record set codeing is not great.  Does any one have any 
 
advice or examples.

I have this code.  The problem is that I can go from "F" to "U" 
 
But I can't go from "U" to"F" 
 
Any help appreciated. 
 
Thnaks 
 
DS 
 
Dim TypeUSQL As String 
 
DoCmd.SetWarnings False 
 
TypeUSQL = "UPDATE MenuInfo SET MenuInfo.ModAction1 = ""F"" " & _ 
 
"WHERE MenuInfo.TerminalID = Forms!MenuCreator2!TxtStation " & _ 
 
"AND MenuInfo.MenuID = Forms!MenuCreator2!TxtMenu " & _ 
 
"AND MenuInfo.MenuCatID = Forms!MenuCreator2!TxtSection " & _ 
 
"AND MenuInfo.ItemID = Forms!MenuCreator2!Txt ...

How do you copy data into a subform?  I have a Word document that has data 
 
that I need to put into my Access database.  Instead of typing each field in 
 
the subform, I tried to to copy the information and paste it into the 
 
subform.  When I open the subfrmMCDetail, all of the information is visible. 
 
However, when I open the main form frmMC, the data is not visible in the 
 
subform.  Is there a way to do this? 
 
-- 
 
S