Search results

Hi All, I have a "Make Table" query. I want to ensure that the table that is produced does not have duplicates in the first field i.e. Indexed: Yes (No Duplicates). Can this be done? Thanks dvent

Hi All, I have a table containing Go Live dates. I want to produce a cumulative total by months i.e. the GL's in April, the GL's in April + May, the GL's in April + May + June etc. I know I could produce 12 queries i.e. one for each month but I'm sure there must be an easier way to do this...

Hi All, I have 2 queries that work out similar pieces of info. The results from the two are shown below: QUERY1 QUERY 2 I want to combine Query 1 and Query 2 to list dates in column A, Forecast GLs in Column B and Expr2 in Column C. I want to then use the table produced to create a...

Hi All, I have a form containing a few fields. I want to be able to click a button to copy the form to the clipboard, allowing me to paste it into an email as an image. Can anyone point me in the right direction? Thanks dvent

Hi All, I have a form containing a number of graphs (each with their own query) as well as a report that displays some information in a table. I want to show the graphs and the table all as one view. Form: Report: Result I want: If anyone can help it would be much appreciated...

Hi All, I have a table containing data like follows NAME NUMBER1 NUMBER2 NUMBER3 JOHN 1 0 0 LUKE 1 2 0 IAN 0 0 3 I would like to write a query that will tell me the max number per Name i.e...

Hi All, I have written a routine to import some excel sheets into Access. This is tailored from another script I use so I know it works. For this particular workbook however I need to delete the first row of data before it is imported. Can anyone help me with adding this line in? Thanks in...

Hi All, Is it possible to set the date value for Date() when opening an Access database? Currently I have a database that uses Date() and my staff change the date of the local machine to the beginning of the following week due to the way some queries are written. Is there a way that they...

Hi All, I'm trying to take a table of masterdata and create a better version. At the moment I have 2 milestones in my data for each milestone - a forecast and an actual date. I am writing the following: IIF(IsNull([Actual_Date]),[Forecast_Date],[Actual_Date]) However I have to do this...

Hi All, I've said this is a very simple question because I'm guessing for 99% of you it is. I have not used DLOOKUP before but know VLOOKUP from excel. I have a table containing Codes with numbers next to them. We'll call this TableCodes. Codes Numbers A1 1 B1 27 C1...

Hi All, I have a table in my database housing a number of locations (over 1100). I also have my base location e.g. SW1A 2AA Is there anything I can add-on to access to calculate the distance between the static postcode and the postcodes found for all of my other locations? Thanks in...

Hi All, I have added some conditional formatting on a report. I have used Conditional Formatting > If Field Value is Less Than Or Equal to 1 (go green) I have a value in the report of 0. When i click on the value in Report view the green shows up however when i click on another value it...

Hi All, Can anyone tell me how to find the Max number in a row if my data looks like this: Name 1.....1.....2.....3.....4 Name 2.....1.....0.....0.....0 Name 3.....1.....2.....0.....0 Name 1 would be 4 Name 2 would be 1 Name 3 would be 2 I would like this number displayed in the last...

Hi All, I have a table with a number of projects (900+) with lots of milestone dates. I want to be able to calculate which phase each project is in based on their dates. Example milestones: Kickoff Phase 1 Complete Phase 2 Complete Final Complete Go Live Complete If KO has a date in...

Hi All, I have a column that I want to set with the format of "Date" but I can't work it out. The formula in the Column is: GO LIVE MONTH: Format([Actual_GoLive],"mm/yyyy") [Actual_GoLive] is found in my master data table with data type - Date/Time Thanks dvent

Hi All, I cannot find the issue with this query field. The error I receive is "Syntax error (comma) in query expression. Expr1: IIf(IsNull([Actual_RL_3rd_Reimport]),(IIf(IsNull([Actual_RL_2nd_Reimport]),([Actual_RL_1st_Reimport])),([Actual_RL_2nd_Reimport]))) Can anyone spot my issue...

Hi All, When a user clicks a button in my access database a table is shown. I want this table to have all columns wide enough to fit the column headers by default. Can anyone explain how to do this? Current code: Application.DoCmd.OpenTable "NiceLookingMasterData", acViewNormal Thanks...

Hi All, I need a few lines to add to a script to open a workbook and save it again in *.xls format. It is currently in *.xlsx format and my macro cannot open it for some reason. The file is declared already as a full path as "excelPath" e.g. C:/Desktop/File.xlsx Can anyone assist? Thanks dvent