Search results

Hi, Sorry for the title of the thread. What I am trying to do is the following I have three columns Name, Date, Number What I need to do is find the difference in the number column where the Name is the same but the date is not ex: Bob 2013-12-12 123 Bob 2013-12-15 456 Jane 2013-12-14 789...

Hi, when running a custom function finding the number of days between two dates I use datediff. However I get overflow when the date is too far away in the future. Is there a maximum or a limit on the number of days (or date) that datediff can return? Cheers Bob

Hi all, I get a report in excel that is formatted quite strangely. I would like to import this file into access. The problems are the following: The file itself has headers -which is good. However, the file itself contains a lot of merged cells which need to be unmerged. The second problem is...

Hi all, Is it possible to temporarily close down bound objects in table as I need to change the data type for a column? SQL Alter will no work, opening the table in design view does not work either.. Cheers Rob

Hi all, I wonder if this is possible? I have a database that keeps track of the cash balance. In the database I also have some securities that can be used as collateral. What I am trying to do is when the cash balance is negative then I would like to be able to use the collateral to offset...

Hi all, I am trying to match dates in a master table called Buckets that contain 65 working days and a consecutive identifier for each workday, for ex wokday 1 has an identifier called D1 etc, to a working table called Workdata. The Workdata table has some dates that are not workdays. How can...

Hi all, I am trying to write some code to populate a table with the nearest 65 working days from a starting point. However since the code ignores Saturdays and Sundays it does not populate the table with 65 days only with 65 days -(minus) Saturdays and Sundays... Does anyone know how to get...

Hi all! I wonder if there is someone who knows how I can pass several listbox multiselects from a form to a query. I have some code that already passes one listbox with multiselects...can this code be adjusted to fit several listbox multiselects? 'Declare variables Dim db As DAO.Database...

Hi all, I have some code that I found on the net for searching on a form using a listbox. I also have in my form a text box that I would like to use in conjunction with the list box. I have the following code: Private Sub Command26_Click() 'Declare variables Dim db As DAO.Database...

Hi all, I am reading in some files from excel into access. I am using the path name and the file name as input factors. Both the path and the file name are static, the only thing that changes is the date ie the the file name is called for example abc_02-08-2011.xlsx The problem is that these...

Hi all, I am running a query with data from a form. The conditions that I am using is date, > argument (greater than) and a numerical value. Ok running only the date and the numerical values works dandy. But when I add the > argument to the same column condition as the numerical values, it...

Hi all, I have a massive excel sheet (350 000 rows 40 columns) that I am trying to get into Access. But before I write code for this, does anyone know which way is the fastest to get in data from Excel to Access? :confused: I have always defined excel as an object and from there got all the...

Hi all, I have a database which imports text files. But if someone is locking a file the code fails. Is there a way to see who is locking the file?:confused: Cheers Bob

Hi all :)! I'm exporting a csv file with transfer text macro (see below) DoCmd.TransferText acExportDelim, "FinalQ Export ", "FinalQ", "C:\Temp\Final.csv" It works like a charm, but I have field in this export that when I bring it up in notepad it shows 2 decimals. The field itself in the...

Hi all, I am running a database on a weekly basis and I want to store the historical data in a seperate database. Transferring the data to the historical database is no problem, however there is no control if the data already exist in the historical database. Is there a way I can say check if...

Hi All, I have a query that gets accountnumbers the account numbers are renamed and consequently they get a date stamp when the account number is changed. I only want the most recent accountnumber. I have tried using a max on the total row in an aggregate query and it is not working - it still...

Hi all, I am working on a form that would hopefully be able to check if a a query has a certain result then it would produce a nice little picture (exclamtion mark) Is there a way to pass the result from a query to a picture in a form? :confused: Bob

Hi all, I have a form with a text box which is linked to a query and a specific field. Now I want to have some of the query's fields to be visible in the form when I enter a value in the text field. But I cannot get the form to update the query so that the results are visible in the form. Does...

Hi all, I am trying to format my union query with a thousand separator but it is not working all that well. This is what I have so far. Does anyone have a clue?:confused: Bob SELECT [DATE],[CATEGORY], [X],FORMAT([SumOfAmount],"# ## 0.00") AS FROM [a] UNION SELECT [DATE],[CATEGORY]...

Hi all, Does anyone know how to update subforms that are in a main form?:confused: Bob