Search results

Hi, I have a table that records user queries for other departments. This has a Date/Time field in for "Date Raised". We changed it from a simple date to Date / Time so we could see what hours of the day were more productive.....We did not envisage being in a lock down with users working from...

Hi Guys, Can you look at the below and let me know why this isnt working? Other Dlookups of the same format are working but this one gets me a runtime error Course = DLookup("[Level]", "[Tbl_Level]", "[ID]=" & Me![Course]) So the field Im looking for is Level on Tbl level. The ID and...

Hi, I have a form on which users can attach photos. This is required for the users to log pictures of machine faults. Is there a way to save these attachments using a VBA button? I'm new to form attachments so i have no idea where to start.

Hi Guys, Its been a long day so i might be being stupid. Can you open a form using the Docmd.openform command, but not use the PK index field? I have a machine table and a field that is Symbol on machine but I cannot get it to open: ID2 = InputBox("Enter Symbol or # on layout")...

Hi Guys, Can someone take a look at the below? I cant seem to get the export to work. It works as far as creating the directory and then stops. No error message or any issues but also there is no exported excel file in the folder! DirName = "B:\" & fOSUserName & "\Register Report\Outdebt\"...

Hi Guys, Need some help. I have attached a picture of a form I'm working on. The form has two query subforms embedded in it. The top subform shows things that have an action required date of <= today. The bottom has things that have a required action date of > today. Clicking on either of...

Hi, I'm having some issues using pop up forms and running them as minimised from a shortcut. My database has been developed using access in Office 365proplus on windows 10. My users are using it on a windows 7 virtual desktop, also using 365 I've set all forms to Pop up, I'm running it from...

Hi, Can someone help me. I cant get this code to work! Literally all i want it to do is run different export queries based on what area the person running it is from. Can anyone see where the glaring issues are that are stopping this from running. Dim Holon1 As String Dim Location As String...

Hi, Im trying to create a form with two sub forms. The first one is a list of activities that need to be done today. This is a series of records with ID numbers. The second is a form showing the details of the record. Can you tell me if the below is possible: 1) You click the hyperlink...

Hi Guys, I have an import statement that doesnt seem to be working I have a table : Tbl_Debt import sheet: import.xlsm import range: Import DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_debt", "R:\In box management project\Media\import.xlsm", True, "import" All the...

Hi Guys, I have a strange issue that I cannot work out. I have an excel import into a table. The table comprises of 5 columns. ID (Which is being imported blank so the table can auto number it. Also the Primary Key), Usercode, CourseID, Progress and Mail. All are number fields and set as...

Hi Guys, I have a query that could have multiple variations as the customer can put in a username as a criteria to produce different variations of the report. I'm trying to get it to export using the Office File Dialog save as using instructions I have found online. I'm doing this as I want...

Hi Guys, I have a table which shows all the sales for my company for a year. I want to create a query that sums all of the sales for each user but also shows some other information. This would then return the Top 50 customers. The query I have so far is as follows: SELECT TOP 50...

Hi Guys, Can someone help please. I have an import command thats not working. The table is a linked table in my back end but that has never mattered in the past. DoCmd.TransferSpreadsheet acImport, , "Tbl_debt", "R:\In box management project\Import.xlsx", yes, "exportrange"

Hi all, I'm running a simple Transferspreadsheet code to export data to Excel. Is there anyway to only export the data and not the field names? DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "Qry_YTDCFY", "F:\NP Report DB.xlsm", "YTDCFY"

Hi all, I have an access database that lists numerous customers in a customers table. This is used in conjunction with a register form to list the customer that a record relates to. I've been asked if I can change the current drop down to change the customer name to add in the customer...

Hi Guys, I'm self taught on VBA and access and I have an issue that I cant figure out. I have 2 tables, one with the current progress of a user through a learning module. The second is a results table to show how many sections of that module the user has completed. I'll then join this to...

Hi, Can you help. I'm trying to open one of two forms based on if a record exists in a table. Can someone look at the code below and see where its gone wrong. the code doesn't do anything. If DCount("Holon", "tbl_Holonsecurity", "[User]=" & fOSUserName()) > 0 Then DoCmd.OpenForm...

Hi All, I have a colleague who wants me to build an access database for him. The aim is to use access to raise and store data on issues that are raised in the company, I.e a part has been manufactured wrong or sales have incorrectly specified parts to a customer. That much in itself is a...

Hi Guys. I have a form and 2 fields are related 1st is a Responsible field which the user selects the user that is responsible for the task. This is a look up value from Tbl_User. Once the user selects the responsible user the form stores the ID. I then have an initials field. This should...