Search results for query: *

I'm using a function to populate a column in a query. I essentially need to take all the records from one table that match the primary key in another and populate the query's column with them. This is what I have: strsql = "big SELECT query returning three fields" dim rst as ADODB.Recordset...

I have a query that picks id fields from three tables (named 'scope', 'categories' and 'title') and creates a ref number from them (the numbers represent system ids, and they're not primary keys or autogenerated numbers). The query in question uses a simple module to build the three numbers...

Hi, I have a sub that exports a set of records to an excel spreadsheet, however some of the records contain just "-" as their value. In all of these cases I want to replace the "-" with a Null value, NOT in the actual database, but just the values exported to excel. Does anyone know how to do...

Hi, I have to export a drawing to PNG (or JPG) for a client but everytime I do my text/annotations seem to get mangled and sketchy -- like it's been rasterised at a low resolution (and consequently, it's unreadable in places). I've been using the 'publish to web' feature and selecting 'extra...

Following on from some outline numering problems I had yesterday ... Does anyone know any way of inserting page numbers prefixed with the chapter number if the chapter does not begin with Heading 1 -- Heading 9 style. I have a new section, and thus a new chapter, beginning with the style...

hi, Is there any way of inserting a unicode character by its u/c id (eg 'fb01')? I'm setting up some keyboard shortcuts for characters such as the degree symbol, angled brackets and fi/fl ligatures using macros similar to this ... Sub dguilll() Selection.TypeText Text:="«" End Sub...

Hi all, I'm trying to use the selected value of a list box in VBA but I can't seem to extract it. I thought you could use something similar to the access form control variables; so just sheet1.ListBox1 or sheet1.ListBox1.value but neither work. Does anyone know a way to do this? Thanks in...

Hi, I can't quite work out why something isnt working, so I just wondered if you guys could help me out. I have a form displaying a record. Nothing strange there. The record is selected from the database and displayed in the form using a filter applied to the form, ie criteria =...

Hi everyone, hope you can help me here. I have a form which I use to add records with two buttons used to exit, 'add' and 'cancel'. I have two problems. 1) If I click cancel, you get the 'is it OK to delete record?' Yes/No box. Clicking Yes is fine but if the user clicks No I get...

Ok, this is the simplest bit of code you'll see all day - that doesn't stop access having a serious logical problem with it though... Private Sub Form_Open(cancel As Integer) Dim upd1, upd2 As String If Me!updatedby = Null Then upd1 = " " Else upd1 =...

This is my second query... Does anyone know if it's possible to check if a field has been updated since a form opened? When I close a form I need a msgbox to pop up if the user hasn't changed a field... It's an updated by/updatded date field on an editing form -- if someone opens the form and...

Hi. I have 2 questions, I was going to put them in the same thread but thought it more useful to separate them. Firstly... is there an easy way of checking which form 'referred' a user to the current one. This is my problem, form A and form B can both cause form C to open. When I leave form C...

Hi, I'm having a mental block - I'm sure this isn't very difficult. I need to be able to change the value of a DB field when a button is clicked... the table is "Sheet1" the field "visible" and I need to set it to 0 on the click of a button - can anyone please help...

I have a form with listboxes from which a user selects a 'group' then if they click on 'add new record' I need to open up the editing form and populate a few fields. My problem is that when I click on 'add new record' the code gives me run-time error 2105 (You can't go to the specified record...

I have a text box on a form which contains a query that uses variables entered on the form. It is basically a way of filtering the list. You type in a keyword or value for any of three fields and it requeries the list with the new criteria. I need a way of counting the records in the list, as...

My database is made up of 6 tables imported from Excel, there are X records each with a primary key called "Unique ID" which was created in excel and imported into access. When I add a new record I'd like to auto increment this value, though access tells me it's impossible to change...

I have a form where you can select a record using two combo boxes. From there I have built a button which opens the record selected using the following code, Private Sub test_Click() Dim Criteria As String If Not IsNull(Me![SubsysSel]) Then Criteria = "[R1] = '" &...

Hi, I'm not sure if this has been answered before... I've looked back quite far and I can't see an answer. I'm sure my problem will be very simple for someone to solve... I have two drop down boxes to select items from a table; the data looks a little like this, R1 R2 Sys Sub 1 0 A...