Search results

Hi I am trying to setup a pass through query to sql to create a temporary table, insert records and pull back the results after they have been passed through a UDF. create table #UAI (User_Abstract_ID varchar(30)) Insert #UAI values ('XURBB_424384') Insert #UAI values ('XURBB_424385') Insert...

Hi I have some VBA which filters a form by date DoCmd.OpenForm "EntryAll", acNormal, , "[dbo_V_ABSTRACT].[ROW_CREATED_BY] = " & "'" & Me![CboCreatedBy] & "'" _ & " AND [dbo_V_ABSTRACT].[ROW_CREATED_DATE] Between #" & Me.CreatedDateFrom & "#" & " And #" & Me.CreatedDateTo & "#" I enter filter...

Thanks for your help in advance, we have built a normalised table and now have the issue of trying to get this data in a form view to both view and edit the data. I have having trouble with which method to use to do this. I have investigated a few methods ADO looks good but I don’t...

Hi, Thanks for help in advance. We have a table with data stored like in the top table. This is normalised and great but while it is easy to create a form when the data is stored like in the bottom table, I am at a loss with how to show forms with this data. Ideally I would like for each car to...

Hi, Thanks for your help in advance, its really appreciated. I am using ADO with SQL in Access VBA, I want to essentially devise a form whereby I can enter using the SQL insert statement more than one record of data through the same form. strSQL = "INSERT INTO tblContacts(" & _...

I have a subform in datasheet view. I would like it such that if I select 'Ratio' from column 'Analyte', in the column called 'Value' I get a drop down with high/medium/low. Then if I add another row adding 'Chemical A' say I can go ahead and add a value (without using a drop down list). I...

Hi, I am designing this database I have decided that using the row entry route for date is the way to go. However I have a couple of questions as it stands I have tables like so: Analytes lookup table ANALYTE_ID CLASS ANALYTE...

For people out there that need to do this in either excel or access here are solutions, I spent last night looking at it and there are some great timesavers. to make fields go from un-normalised to normalised use select sample as Sample1 , " value1 " AS col, Value1 from Table1 where value1...

Thanks for your help in advance. As a quick test of mental agility on a cold afternoon, I have a quick question. Two tables with numbers like so Table A Table B NameID Number Number AA 1.5 2.3 AB 1.6 4.9 AC 5...

Thanks for your help in advance you have saved me an a number of occasions now. I am about to built quite a sizable database and need help with the table structure. The database will contain lots of values of chemical tests from rock samples. If I was to have each chemical that could be...

Morning, I have a form in Access 2007 that uses tick boxes, this is looking through ODBC connection to SQL server 2005 bit fields. This works ok until I want to filter by form when I do so the filter puts the criteria as -1 whereas it will only work if true or false is input in the criteria...

Hi, I have used the control wizard to create a combo to find a record in the list and return the entry. I currently have 150000 records in the database, less that half are displayed on the drop down list and I am unable to jump to records past the list. Eg. I can find all records beinging A -...

Hi, I have mdb frontend, SQL backend, I am trying to update a linked tables in linked table manager, i select all the tables, click prompt for new location and then press ok. When I used access 2007 I get the error 'ODBC--call failed' and I cannot even select the dsn I want to change it...

Morning, I have been struggling to get this going for a couple of weeks now. Could you please take a look at let me know where this code is going wrong. Many many thanks Q.SQL = "Select * From [Q_SeqStrat1] Where [Country] in ("Egypt",) And [user] In ("Depth",) & ";" Basically it comes up...

Hi, Thanks for the help in advance, this website is a goldmine. I hide tables using the HideTables module, this works when I run the command button, go back to the navigation pane and press F5. Is there a way to refresh the tables on the navigation pane using VBA. Many thanks for your help...

Is it possible to hide individual queries and forms from the navigation panel like you can with tables. using the code: Application.CurrentDb.TableDefs(sTableName).Properties("Attributes").Value = dbHiddenObject Cheers, Oliver

I have used make table queries for a long time sending tables from one access database to another database. Yesterday I tried to send a table from an Access 2003 to an Access 2000 database. One of the fields - contains a 5 character code and then a _ and then 6 digits - like CGTDD_234234. When...

Morning, I am trying to open a form in read only but the script I run doesnt seem to do the job. Private Sub CmdGoEvent_Click() DoCmd.OpenForm "Tbl_localData", , , "[Sequence_Interpretation] = " & Combo4, acFormReadOnly End Sub Thanks, Oliver

Hi, Small question, I am trying to query a report so that when it opens up it only opens a specific copywrite holder. To start I have an unbound form with a combo box from which a person selects a copyright holder. This combo box is "SelCopyReq". Then I run some script on a go button below...

Hello, New to adding SQL script in VBA so looking for your wisdom. In this database people make requests for a piece of data, is the data they request has already been requested I am looking for a popup to tell the enterer that this has already been requested and the status of the request...