Search results

I am not sure I understand what you mean. The items displayed on the calendar does not require VBA code. But these buttons do need a code that should prevent counting all Task for both site locations.

I have a form which shows the task of employees for the whole week and it works like a calendar. The is a small circle on top of the button Previous and button Next, which shows the number of tasks in the previous and next week. The problem is, I have to manage the task calendar for 2 site...

I did but somehow it still appears. But then I changed it to If Messdauer = False Then Exit Sub Then it works. Thank you for your idea :)

Thank you for your replies :) That will only stop the InputBox from making any changes. After that, the MsgBox appears. How do I stop the MsgBox from executing, when I the Inputbox is canceled?

I have a button, where if I click it, it will promt a MsgBox and InputBox before the action is done. Private Sub btnWorkDone_Click() Dim WorkHours As Integer On Error Resume Next If Not (IsNull([datTransferIs]) Or IsNull([datTransferShould])) Then WorkHours =...

I have tried everything but nothing works. Everything seems to be on the right place. I also tried copying the Backend to my hard drive and make a linked tables to my frontend, still the form won't show the record in frontend. And I don't think the data is heavy because I have other forms that...

So I have this form that will display the task of employee for the week. I have posted a thread about this before. Here is the link : https://access-programmers.co.uk/forums/showthread.php?t=293894 There is a huge TV that opens the database and display this form BUT it is a backend. I want to...

JHB, I tried Me.Requery but nothing happend. Closing and opening it again is also not an option because that is what I have been doing before. That is why I need a button to simplify the work. Cronk, I tried the me.MyCombo=null code, but it will only reset my combobox to Null, my subform and...

I have a few comboboxes with filtering type and a subform and when I am done with my work, I want the form to be reset as if it is just loaded. I want to have a refresh button on my form so that when I click it, it will return the form to it's original untouched form. I tried adding a button...

I was thinking of a code that will only show the value that we want such as cboCountry.value = 1, 4 ... (for example) but I am not sure if such codes exist. I thought about that option group too. I am mot sure how it will group together the records. So maybe I should just change to combobox...

I know that if the combobox is a Table/Query type. But mine is Value List type.

Hi, I know I have posted something similar before this (link below) but this time it is quite different. https://www.access-programmers.co.uk/forums/showthread.php?t=293754&highlight=list+filter In this new case, I have a combobox with value list type and an option button that will filter the...

Hello The Doc Man, I am not sure what you meant by "did you do things to your front-end settings using the path File >> Options >> Current Database?" Is there anything that I should check/uncheck in the Cureent Database Option? As far as I'm concerned, I did not change anything there.

Thank you very much for the clean explaination! I believe my case is Case B, but I don't think I want to add new field or tables. I have the "design master" version of my database, where I design and edit the layout. I just added some combobox to make filtering easier. On the special Form...

So nobodyever works with the Backend? Just me? :confused: Okay I tried to activate the Form in Frontend, but it it does not show any data. This Database is created by my previous employee so I am not sure what he had put in it. Is it possible that he write a VBA code so that the data is only...

For some reasons (that I also don't know), my team uses both Frontend and Backend. The other employee uses the Frontend to key-in data. The leader uses the Backend. I know the Backend only stores tables but mine also have the Form, just like in Frontend. For example, see the picture. There is...

Thank you Orthodox Dave for the reminder! I absolutely missed your reply. I will check it out. Thank you again :)

I have a Backend and Frontend database. I am updating the design and adding some filter in the frontend. How do I synchronize the design so that the Backend also have the same design as the Frontend? See pictures for example.

My Linked Table Manager is grayed-out/deaktivated. I don't know how to make it available.

I have a split database - frontend and backend. The backend database is located in a shared location, let's say, Folder A. As the work expanding and the database needs to be shared with other branch, the backend database will change it's location to Folder B. I have made a copy of the backend-A...