Search results

A function imports a row of hyperlinks into an Excel spreadsheet that look like text... =HYPERLINK("https://webistename.aspx?ID=3&WA=1","A110912") The problem is that they don't act as a hyperlink until I physically click in each cell and hit F2 or <enter>. After that they are displayed as...

Hoping someone can help me with this DELETE query. I have a Main table that's being updated by a Temp table that's an exact copy of the Main table but with a subset of records. 1) Insert records from Temp table NOT found in the Main table - this query I have worked out below - not tested, but...

Hello, I have a text file I'm querying that stores a field as a text. ComponentID:0000000242 I'm inserting this data into a table that stores this value as a number. Thus truncating the leading zeros. ComponentID:242 I would like to create a query on the table using an InnerJoin on the text...

Hello all, i have a linked table in Access to SQL Server. I'm running a simple select statement in Access on the table. select * from tblData; When I do this it brings up a parameter pop-up to add a [dtDate] field entry in the query??? The [dtDate] field is not in the table or in the above...

Hello, I have an Access query that returns one record. However, using ADO I open the same query as a recordset and it gives no results(rs.EOF = true and rs.RecordCount =0??? Any ideas? Hoping that someone has had this happen and can explain without posting all the code. Dim cn As New...

Hello, I'm doing some testing of a function and would like to run the function directly without going through all the steps it takes to get to that point in the application...ie clicking buttons and selecting records and such. Is the a way to locate the function I want to test and run it...

Hello, Any thoughts on how to get Access to recognize the DefaultValues set in SQL Server? I have default values set up in SQL, but when I open the Access table in Design, they're not showing up. The Required property of the field comes through but not the DefaultValues? This is causing havoc...

hello, quick ADO question... Must I (set rs = nothing) when I'm done? I've always done that, but seeing a lot of code that neglects doing so. Is it advisable to do or can I merely use. (rs.close) What are the consequences of not setting = nothing? Also, should I wait until I'm finished with...

Hello, I have an Access to SQL Server linked database with a VB front-end. It seems to be linked correctly and permissions seem to be set up fine. I am able to execute queries of all types, select, insert, update from vb. I am also able to run ADO code to update the recordset. However, when I...

I would like to create a "global" temp table that can be viewed by all users. The syntax is: Create [TEMPORARY] TABLE tablename (field type) QUESTION1: When I put the optional [TEMPORARY] in, I get a syntax error... Create [TEMPORARY] TABLE t (ID int) I've tried... Create TABLE [t] (ID int) Is...

I'm supporting an app. that I did not create that has different "types" of users. There's a button that's supposed to fire an event. It works fine when I'm one type of user, but if I log in as another type of user, the event never fires when the button is clicked. I've set a breakpoint in the...

Hello, i am trying to join the results of a many-side of a query into one result field separated by commas... Table: tblWorkOrderStoresFinal Row 1: LogNumber: 1 StoreNumber: 2 Row 2: LogNumber: 1 StoreNumber: 3 Row 3: LogNumber: 1 StoreNumber: 4 I would like to make a query that combines...

Hello all, "Filtering" a recordset I have a DAO.recordset that gives me sales for a range of dates pulled from SQL Server. Once I've connected to the Recordset, I would like to apply a "filter" to the same Dataset several times to find a particular salesperson, crunch some numbers, then remove...

Can someone give me a hint as to how to call a module from VB? I've created the module modUpdateTables, but I can't find out how to run it from my code. I've looked in the help, online and otherwise. Anyone know how that's done? Thanks, Casey

I have a Main Form that utilizes tabs to control several other forms by opening, closing and making them visible/invisible. One of the forms needs to be closed when its tab on the Main form is unselected. The problem is that once the form is closed, when it opens up again it opens right infront...

Hello All, I'm trying to run a UNION query that joins five queries through a MS WorkSpace into a DAO.recordset in VB. I'm pulling the data from a SQL Server Database through VB in Access. I'm attempting to open a recordset with a query passed to it as a string. The query is below. For some...

Hello, Can someone direct me on changing the Lookup property on a boolean field I've created using the CreateField DAO method so the field is a checkbox? I would like it to be a Checkbox type, but do not see a way to do it using DAO. The way I've done it below gives me a 0 or 1. I would prefer...

Hello, I am trying to delete a set of tables using the TableDefs.Delete method. I would like to specify a TableName and have VB search the TableDefs.Name to see if that table exists. If it does, I would like to delete it. If it doesn't exist, I would like to search on the next TableName. I...

I'm trying to trouble-shoot an undocumented datbase built by someone else and running into a recurring problem. She has it set up where a macro runs several queries. When these macros are run, the queries cause "Division by Zero" errors which stops the macro in its tracks. The following is a...

generate a table from a sql string VBA/DAO Is there a way in VBA/DAO to create a table off of a query. I would like to reference a query and generate a table that's a direct copy of the data in the query. The ideal would be if a query could be selected and a table name could be generated...