Search results

Hi, Whenever I want to search something I get "A server error occurred." I tried Google Chrome, Microsoft Edge Chromium and Internet Explorer. Had cleared all cache and browsing history. Tried both on my laptop and desktop. Best regards, Siegfried

Dear experts, In all the examples I came across on the internet so far for an Employees Table, I notice that only a hire date and, at times, the date of birth are mentioned? Is it incorrect to add an employee end date in that table? EmployeeT EmployeeID_PK EmplFirstName EmplLastName...

Dear experts, I’m trying to set a default for a field (ExchangeRateID) on my form but I’m not getting any value (?) On my form PurchaseOrderItemsFSub (the recordsource is the table PurchaseOrderItemT) I have following fields: POItemID PK POID FK ProductID FK ProductBrandID FK ProductModel...

Dear Experts, Is it possible to do query basis lower or uppercaps of a field in a record? In our company a Capex is numbered with a letter but both small and upper exist: Capex number AEANT20a (for amount under 500 USD) Capex number AEANT20A (for amount above 500 USD) 20 being they year...

Dear experts, I have placed on my main menu form command buttons with an picture to access forms/reports. The picture in the button is gray by default, I created the same button with a orange button and set it hidden Underneath the command button I put a textbox with label. The label gives the...

Dear Experts, I need your advice on a Foreign Key issue, let me explain with an example. I have set up the following 3 tables: EmployeeT EmployeeID PK 1 FirstNameID FK Ward MiddleNameID FK LastNameID FK Peters PreferredNameID FK...

Dear Experts, I have a set focus issue on my form ADUserF when creating a new record!? The form has a text box InfoNotes, set to field size 255. I've added an unbound text box textCharsUsed to display the remaining characters available when typing in comment in the InfoNotes field I have...

Dear experts, Appreciate if you could help me with the following issue I'm stuck with. I have a continuous form EmployeeDashboardF. On the form I would like to display a label with a colored dot basis the content of the text box EmployeeStatus. I have following 4 labels: show lblblack if...

Dear experts, I'm trying to figure out how to change the OptionGroup background field to color based on the value of the option button. I found that the control is transparant: OptionGroup.BackStyle 0 and can be changed to normal OptionGroup.BackStyle 1 and then the interior color can be set...

Dear experts, I'm trying to figure out how I can mark values as "available". I have a list of 50 phonenumber which are available on our phone exchange. I have this an excel where it shows the telephone numbers sorted and behind the number the name of the employee who has the number assinged...

Dear experts, I keep struggling with cascading comboboxes. The examples I find on the internet usually don't match my more complex requirement... Can somebody please guide me and help me out. I have a ton of excel files which I want to get rid off by using Access. Hence I'm trying to create...

Dear experts, Calling once more on your expertise. I have a form that lists all employees (FrmEmployees.EmployeeID) with their job title (JobTitleID). I want to display on the form in a separate field the total employee count of the hired employees and, if so applicable any temp seperately ...

Dear experts, Would like to ask your advice. My QA department asked me to make a small Access database where staff can watch video tutorials. As the video's are company owned, they aren't allowed to access and download them directly so idea is that they access a dbse and then can select a...

Dear experts, I'm breaking my head over the correct setup of my tables in order to be able to enter value in a combobox based on the selection in another combox in the form :banghead: The database I'm trying to build will keep track of all office related purchase records (desks...

Hi Everyone, My first post for 2016. Happy New Year! I'm getting a return without GoSub (Error 3) the first time I open the main form when I start my dbse. The form shows several labels which give a count result. Private Sub Form_Current() If Me.NewRecord Then...

Dear access experts, I've been browsing the Modules & VBA discussion groups in the hope to find a VBA code example for sending a record to Outlook. I don't want it to be sent as an attachment but in the body of the e-mail which the user then can send out to his recipient(s). Hence once the...

Dear Experts, Appreciate if you could help me out with the VBA code for displaying record count of a subform in a label on the main form. I found following code to display record count in a label. Private Sub Form_Current() If Me.NewRecord Then Me.lblEvent.Caption = _...

hi everyone, I have a hyperlink on my main form (frmMainMenu) which, onclick opens another form (frmSlowSteaming). When I close that form I return to the main form but need to click the refresh all button in the home tab to be able to use the hyperlink again. Can I reffresh this action...

Dear Access experts, Can you help me out with subject error? I'm trying to display the date and time entry in the textbox DeliveryDate on my form frmVessels without the seconds, but keep getting #Name? and #Type? errors. I'm spuzzled...:confused: Made following module: Public Function...

Dear Access experts, Would like to ask your help. I'm building a dbse in Access 2013 to centralize certain data about the vessels we are managing. I want to get rid of the dozen of excel files, with incomplete and or duplicate information, and consolidate all information into this dbse...