Search results

I need abit more assistance. I've tried that and so far not working. I need the form on workstation 2 for example to update when another user on another workstation adds a new record to the form. At the moment the user has to exit the form and go back into it. The name of my form is Details...

I have a split database. I hope I can explain this well.... I have a network mapped drive on all computers (win xp pro) of G:\ I have obviously a front end that was created when it was split. I keep that fornt end file in same folder of the backend side of things, and I simply copy that exact...

That works and when I go into print preview it appears as how I want it but when the report is actually printed, all I get is a 'Name?' message in the actual printout where it should be showing the date.

Thank you Gemma that worked perfectly :)

I have a report that is connected to a filter that is connected to two calender controls. The user loads up the relevant form and choses a date from the 'Date From' calender control and then selects another date in the 'Date To' calender control and then presses a macro button which then...

Whenever I check or uncheck a check box in my forms the label that is associated with it is surrounded by dots. I'd ideally like to get rid of this even though it's just visual as it would improve the look of my form. Anyone know how to do this?

I have a silly report problem. I have a form and on it has many fields and a few check boxes. It also has around 9 cmdbuttons to print off certain reports/company letters that contain certain information in them for various purposes. I have setup a query called 'All' and macro and obviously...

once again, thank you that works fine :)

The above code works perfectly on the form side of things, but now I have created a report in Access and I have all the fields in and all formatted to my vision I have a new problem that may require VBA code to fix. In my previous post above I talk about a check box, and it's this check box I'm...

Thank you so much - that code works perfectly in my database.

i shall try that, and keep the code in the after update too? What do you mean by single view form? This form will be accessible or will be accessible to up to 4 users on 4 pc's over the lan network. I shall try your recommendation and get back to this thread to resport on results. Thank you.

I'm in a bit of a mess... Okay, I have some VBA code that causes a label on my main form to change depending on the value that is in the check box in the record. The idea: The idea of part of my form is for the user to have to check a tick box to know that the 'thing' can be released. It's to...

I have a text box called 'txtvalue' and whenever an amount is entered into that field I would like the tick/check box which is called 'deductable' to be True. Can this be achieved and if so how? Thank you.

I have a big problem. I like to create databases in Access 2007, and I can convert them/save them to the 2000 format as easily as everyone on here can. However, when I use the database on Access 2000 the forms get very messed up. In this screenshot is how my database looks in Access 2007...

I'm creating charts in Excel 2007 and they look fantastic, and I can save them in various formats which when opened look exactly like the version in Excel 2007. However, when I transfer those files into Word 2000 as a Jpeg, BMP or PNG the image seems to downgrade slightly and even becomes...

No that does not work. I think you think that I'm refering to the actual tabs on the window things. In my Access 2007 form I have inserted a tab control (called 'TabCtl0') and in that I have fields. I have set it so it has three tabs. I then save it as a Access 2000 format and open it up in...

I have created a database in Access 2007 that now works well, and one that I'm quite proud off. However, I can easily convert it to an Access 2000 format as can anyone else here, but when I load it up there is a major problem. I have used the tab control in my main form and that has three tabs...

Hello all. Not read this thread for a few days, but I do need a soloution to my problem if possible. I have the report constructed and entered the following code into the VB code builder: Option Compare Database If Me.TickRelease = True Then Me.LabelRelease.caption = "Vehicle Can Be...

Okay, everything seems to be going right. Forward my computer's clock and trialed various dates and they appear to be working. Thank you for assistance.

Getting there I think, but slight problem. I use the following code in the module: Public Function PlusWorkdays(dteStart As Date, intNumDays As Long) As Date PlusWorkdays = dteStart Do While intNumDays > 0 PlusWorkdays = DateAdd("d", 1, PlusWorkdays) If Weekday(PlusWorkdays, vbMonday) <= 5...