Search results for query: *

I would like to make tables for user input as to what tables are required and what fields need to be in the table. For example: Have a table that has the following fields TableNameID FieldName DataType Description Then have a form that the user types this information in, and a command button...

This is possibly a very simple thing I am trying to do, but for the life of me I can't seem to get it right. I am trying to set the name of a control in vba and then set it's value to a stored value. Method 1 (Which Works) eg. Dim MyCtl as Control Dim MyFrm as Form Set MyFrm = "frmABC" Set...

Open my form with all records, then after pressing a button I want to calculate programmatically how many records there are so that I can use that number in a do loop statement

Using the code: Dim Check, Counter Check = True: Counter = 0 ' Initialize variables. Do ' Outer loop. Do While Counter < 20 ' Inner loop. Counter = Counter + 1 ' Increment Counter. If Counter = 10 Then ' If condition is True. Check = False ' Set...

In Excell, using roundup produces the following results: ROUNDUP(45.2,-1)=50 ROUNDUP(45.2,0)=46 My 1st question is: Is there a function in access that will produce the same result? Secondly, if not, how to go about writing the code? Thanks for now

I have a form with a subform, and the subform has a subform also. On the main form, in the form header section I have an unbound combo box from which the user must select a client. On the after update event of the combo box I want the focus to go to a record on the second subform so that data...

Has anyone ever used the MSComm32 control in Access, if so what is the correct way of getting the data coming in on the serial port to be displayed in a text box. I have used the control from VB 6.0 and it works great but Access doesn't seem to support the MSComm1.Input method. I have posted on...

Has anyone ever used the MSComm32 control in Access, if so what is the correct way of getting the data coming in on the serial port to be displayed in a text box. I have used the control from VB 6.0 and it works great but Access doesn't seem to support the MSComm1.Input method. I have posted on...

Has anyone ever used the MSComm32 control in Access, if so what is the correct way of getting the data coming in on the serial port to be displayed in a text box. I have used the control from VB 6.0 and it works great but Access doesn't seem to support the MSComm1.Input method. I have posted on...

Even though my question is VBA related, a VB front end will do. I have posted several times trying to find the right way to read data coming in on the RS232 port(eg. Com1) but have received little success. Can anyone help me with this problem. I have an electronic scale that has an RS232 port on...

I have a new project I'm starting and it involves a scale connected to an RS 232 device, I want access to read the values from the port and possibly do some conversion thereafter, can anyone point me in the right direction? Umbane

I need to make a report that will show me all the the data not filled in in a particular record. I have 91 fields that I need to query and only those that are empty I need to indicate on the report in some way. By placing all the text boxes in the report makes it too long so I want to code some...