Search results

There is one instance of the project table. SE1 Client Table is the SE1 one. I want to export the result of my query to excel. I have done this successfully using: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Spot_Pairs_Query", filepath, True, "SpotDataDrop" But only when...

I have a query which works fine if you enter and run it from the Access query window. However one element of it is variable so I want to run this from within vba. It is a select query that creates a neat two column table from a range of different tables etc. I tried do: strSQL =...

Thanks for the link. That helped explain some of the concepts. But I still have the problem. I now think it might be an access bug. There was some mention elsewhere on the web of it being a service pack issue. I have SP2, do you think it is worth moving to SP3 due to this? Has anyone been...

Having a nightmare with this combo box. Spent ages surfing the web for solutions but nothing working. I have a form. I have set the record source of the form to the query below which i built to fill my combo box. I have set the record source property of the combo box to this query too...

Thanks for your advice, I am new to all this so it is appreciated. To save re-doing all my queries, perhaps I will create a table for the new project, and once all the processing is done, send it the results to a master table (structured as you suggest) and then delete the temporary project table.

i think i see what you are saying so the projects table would have multiple projects with the project id being specified for each record. it seems to me much more intuitive to have seperate tables for seperate projects from a standpoint of segregating data, running efficient queries, inputing...

Each project involves the analysis of around 10,000 records. These need to be store in a seperate project table. The project directory table just stores the details of the different projects - like id, date, name. The form being discussed is used to create a new project table, and update the...

I wish to create new tables to keep each project distinct in the first instance, i may combine to one master table later. The forms purpose is to record the project name, id, details in a "project directory table", and to create a new table for the project. not sure why that would be bad...

Sorry. Full code is: Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord , , acNewRec stDocName = "CopyProjectTable" DoCmd.CopyObject , "Project Table " & ProjectIDText.Value, Table, "SE2 Project Table" End Sub Form's record source property is set to "SE12 Country Directory"...

When I add a new record with: DoCmd.GoToRecord , , acNewRec How do i get the Autonumber to update for the new record. It is the first field of the record, Unique Project ID ? Thanks

Seems to work. Thanks a lot!

Thanks in advance for any help. I have a table 'Project Table 1' and a query Source_Rates. The following inner join query works nicely, adding two columns to 'Project Table' with the correct details from Source_Rates. SELECT [Project Table 1].* , [Source_Rates].[Rate1]...

I found the solution. Your posts have still been v helpful. Perhaps the solution will clear up the problem! Sry wasn't clear in first instance. I've built 5 querys: Query1: SELECT [Date1], [String1] FROM [Project Table 1] WHERE Not [String1] Is Null And [String1]<>""; Query2: SELECT...

Start point is a table with column of dates, column of currencies (string1), another column of currencies (string2) with some blanks, and a final column of currencies (string3) with some blanks. I want to get to a table with a column of dates and a column of currencies. This table will be...

Thanks for all your help! It was AND in the end and this is working really well now. For completeness here is my query. Final thing. I now want to seperate the currency and date in the result. I was thinking of dumping this result in excel and using the left and right excel functions. Is...

The select distinct query doesn't seem to be working for me. namliam - i wonder if this is because of the point you make about data types. I have a table with currencies, and dates. There are no blanks in the dates, but some blanks in the currencies - for good reason. So it looks a little...

I have the following code. It creates an identifier with String1&Date1, then gets all unique records. Then creates an identifier with String2&Date1, and gets all unique records. Then again with String3&Date1. I use Union to stack them all together. But then i want to make sure that there are no...

.. that prevents it from being opened or locked. There seem to be more comprehensive posts on this error, but they focus on multiple users accessing the database. I am developing a new database. I have the code below, which works once. But run it a second time and I get this error and have...

This works nicely :D but there is an additional thing I need it to do. Some of the records for String2 and String3 are blank. But the corresponding date is not. So the identifier String2&Date1, just returns Date1. I want to skip over these an not add them to my unique list. I tried the...

Thanks, i'll try this. Could you explain "denormalized data structure"?