Search results

My question is how do I fix the following issue: All of the fields i have no issue with getting the information other than the "ACCOUNTEXPIRES" field. It is because it does not convert correctly or i have a bad setting. The following URL is something i tried, even modifiying with my limited...

If you are trying to hide something, all you need to do is create a macro and in the condition make the check yes or no, then the macro would be setvalue, and make it the checkbox visible properties, yes or no That will hide /unhide it You also must put the macro on the form (not on the...

Im really bad at making many to many relationships, I quickly get confused, could someone please sort this problem for me. This is for a doctors appt book. I have a table for dates, I have a table for appt times (do I need both? maybe combining?), I have a table for patient. A patient can have...

I am needing some code for a calendar in Active X. I have created a calendar and a bound field called date. I have made so that when I click a date on the calendar it also shows up/changes in the bound field of date. I also have a subform that is bound to date so that I can add times and...

Is there anyway in a subform, to define each row, although they all share the same field names in each row, i would like to be able to write some code that says like add row 1 and row 2 of a subform.

Is there anyway in a subform, to define each row, although they all share the same field names in each row, i would like to be able to write some code that says like add row 1 and row 2 of a subform.

Heres some code I came up with, follow the instructions from Microsoft at this link, http://support.microsoft.com/support/kb/articles/Q209/9/90.ASP?LN=EN-US&SD=gn&FR=0&qry=OLE%20class%20name&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000 and add my code. Private Sub cmdOLEAuto_Click() On Error...

Can someone tell me how to import a .jpg into the database by clicking on a single button. I want to import it from a directory such as c:\temp and the file like test.jpg I know that it will require VBA to do it, but I cannot find the command to copy a .jpg into an OLE object, which is what I...

Can anyone come up with some code that can import the contents of a .jpg image from a file on the harddrive such as c:\temp and place it into a record, or copy the contents of the .jpg image and then paste it into a record. Thanks tons in advance. PS Charity, if you do this one contact me at...

Ok you following along what I was doing, but my problem appears when I add the first line. Example MainForm [fielda]=10 Subform [Field1]=1 [Fielda]+[Field1]=11 Now I want to take that 11 and place it into another field and add that field to fielda + field1, but when I do the totals dont add up...

If I have a field called [field1] in a continuous form, how do I access the data in record 1 or record 2 of [field1]. Is it an indicie? like [field1](1), [field1](2), etc.. I am trying to add a field from the main form and keep a running count on the subform . Example Mainform [fielda]+ Subform...