Search results

Hello Guys & Gals, I have function that gets called thousands of times throughout a process, the method i am currently using envolves opening and closing the recordset per interation. The reason i do this is because the criteria changes per time. Here is the code, i am a self taught coder so...

Hi, I have two tables i would like to create a relationship with but the two fields that i want to join are not exactly the same e.g Table 1 0000111111 Table 2 111111 ABC The key piece of information that i would like to link together is the 111111, in SQL i would just type "WHERE Code LIKE...

Hi, I have tried a fee different methods but none of which are giving me exactly what i need, i was hoping some one out there might be able to suggest a good approach. I have the following data. Source ID , Product , Price , Count 1 , F2 , 10 , 6 1...

Hello all, I am having trouble creating a query, here is the query i am having issues with SELECT a.app_num, Max(b.app) AS Highest, a.prod_code FROM table1 AS a LEFT JOIN table2 AS b ON a.prod_code = b.GSN GROUP BY a.app_num, a.prod_code; Now the query above works fine with out the...

Hi Guys, I have got a query that updates details from one table2 to table1, "Reference" is the primary key and this is what the query uses to determine which need updating. It all works great but if table2 contains a record in "Reference" that is not in table1 i just want it to ignore it...

Hello all, I am trying to write a query that deletes all records from one table that meet the criteria of another. The table i need to delete from is called StartingPoint and the other table is called R7e, both tables have a field called "Reference" and R7e has a field called "Change". I have...

Hello all, I have got two questions i would like to ask y'all. 1. I have created a data input form that feeds directly into a table is there any way i can protect that table so it can only be viewed by me but the form will still be able to feed in it. Something like a password system would be...

Hiya guys, I have got what seems to be a pretty straight forward task i need to do! I have got a table named tblInput, with four fields Type, Collection, Value and Reason. I need to give the Type field two possible options "a" or "b", i then need the Reason field to display a list of values...

Hello everyone, I have got an update query that i use to update a main table. The query uses two tables, "StartingPoint" & "UpdateFuture". "Reference" is the primary key in StartingPoint and is also in UpdateFuture table but not as a primary key because there can be multiple instances of the...

Hi, Could anyone please tell me what is wrong with the following SQL? INSERT INTO TableB_Rejected ( Rejected, Reason ) SELECT TableB.Rejected, TableB.Reason FROM TableA WHERE (((TableB.Rejected)<>"")); I am tring to take all the fields with data in from one table and put them in another, i do...

Hello all, Is there anyway i can create a query that will effectively move records from one table to another, or will i have to create to separate queries, i.e an append and delete?? Thanks a lot everyone Tim

Hi, I have created the following function in my datebase so that i could specify the date a query works from. Option Compare Database Function GetParmValue() As Date GetParmValue = InputBox("Please enter the date you wish to update!?") End Function I have a button on a form that runs...

Hi Guys, I have got a toughy here (well, for me anyway) i have got a collection of data which i will refer to as the starting point, every day i will be importing some new data into a seperate table called daily download, on this new table will be an effective date, some dates will be the...

Hi everyone, I am using the following code as an import button on a form, everything works and it imports the data but for some reason it imports several blank rows as well all the other data? Private Sub bImport_Click() On Error GoTo Err_bImport_Click Me.tbHidden.SetFocus If...

Hi all, I have been browsing throught this forum and found there are some excellent Access users out there, i however, am relatively new to this. I am starting to learn quite a lot though and have taken a lot of information from this forum, my question is this; I have been set a project...