Recent content by Dalain

It’s OK now, I got it to work. CommandBars("EditView").Controls(11).State = True I had to move a button that was capable of changing states, like the justification ones, to my custom ToolBar . Then I changed the Button Image and the On Action code. Now it works. It seems that only...

Doing well, thanks AceMan. Good idea, but when I tried it, it didn't work. There was no error code, just not highlighted. Do you have to update it after for it to work?

I’m trying to highlight a button on a toolbar using VB based on information on a form. This would be similar to how the Justification (Left/Center/Right) on the formatting tool bar works, when a field is selected. I have tried SetFocus, but this does not work as it moves the focus to the...

I have a “personnel information” database where an OLE Object field is used to display the picture of the person that the record belongs to. I use to be able to insert (Create from File) any picture format I wanted (Bmp, Jpg, Tif...) But, now I can only insert GIF files otherwise it is...

hello blakey2 There are are alot of good answers here. So I just wanted to add my bit to it as well. For starters, no matter what format you have selected for your System date, at one point or another when converting the Date from "text type data" to "date type data", ACCESS will READ the...

Well here is some more for you brain. In order the Help more, I would need the know more how your report is working For example Main Report (RecoreSource? , All Records or no records) |--Sub1 (Link Master/child value, Recordsource) |-Sub2 (Link Master/child value,Recordsource)...

Hi Ashij Just to see if i understand correctly, the subform only shows a picture? If not, it should. If there is any other info that is displayed, you should have it in another subreport. If this is so then you don't need to have code in the subform module making the picture visible. Instead...

in the query that defines you list, edit the query and enter Accending in the field you want to sort by. the List box Row Source, which is SQL code, would be : SELECT Table1.Field1 FROM Table1 ORDER BY Table1.Field1; Dalain

For me, we have a network that is accessable to all parties (16 I think all over the city), for example if the two companies A & B were able to share a network, then all you have to do is place BE that contain the common information in the shared drive. (they then would map the drive to have...

Open the form in design mode then in the Form properties and under Recordsource enter the name of the table(click the down arrow, or click the three dots and create query. if the form is in normal mode, you can create a table with the field called strRecSource (text type, 255) Enter the name...

For the Main Access window you can change the Application Title from the startup properties under Tools/Startup..., or you can do it using VB by entering the following in a module (this way you can change it a any time) ChangeProperty "AppTitle", dbText, "Your Caption Here"...

One way to do this is in your BE table create a field called RecChanged (Yes/No) Then in your FE, have a form's timerval set to 5 sec (5000) then in to onTimer event do a Dlookup on the field. So eevery 5 sec the form will search for a True value. If found, then active the popup message. This...

It figures, someone like PHV would find a shorter way. I didn't think DateSerial would work if the day value was grater than 31, but it does!![thumbsup2] Dalain

The form does not nessarly need to be hidden, as long as it cannot be closed without closing access. On the forms Timer interval Event enter 86400000. (1000 = 1 sec therfore 24hr = 86400000) then on the OnTimer event of the form You should also be able to set the time to send the email For...

If the sub form (frmSub1) is already open elsewere before you open the main form, the subform "frmSub1" will be blank. You must ensure that all forms that contain frmSub1 as a subform and the frmSub1 form are closed first, then when you open the main form you should be able to view frmSub1 and...