Search results

I am trying to help a friend out with delete query he needs, but it is beyond what I can do. Here is the table structure: tblSomething - ID (PK) - RVersion - RHost - RUser - RLocation - RDateTime - RCompleted Now, the program that enters this data cannot be edited, so whenever the...

I have a query that goes through a list of TV programs, and puts them in order by Time, and then by Channel. The channels are sorted by their ID number, 1, 2, 3, 4 or 5. This works fine to put things in order, however I have come across a situation where I need to change the sort order a little...

Hi everyone, I am finally almost finished with my application, and have one last question, I think. :) I have one command that runs insert and update queries, but I am wondering if there is some way to turn of the prompts on a project level, not on an individual PC level? I can't turn it off...

This is more a matter of discussion here, but I have been delving a little into using unbound forms for everything in access, and using VBA "SQL" statements to select, and insert data. I know using bound forms is easier, but I am wondering if relying on them will hinder my work flow if I come...

OK, this my trickiest problem yet I fear. In my application we enter dfata into a form, and then hit a command button, and it creates a word file from the date based on a number of SQL queries. The problem is that there are a few choice words in the document that need to be made one size...

I am trying to work out how to insert an EnDash into a Word Document, but it seems this not going to be possible. The Command in Word to do it is "Ctrl -" though the dash is the one from the NumPad. I have tried doing a sendkeys with the normal dash and it does not work, is there a way around...

Hi everyone, I have a form that has two text boxes, in the first you enter a 4 digit number, and on exiting it (LostFocus) is automatically adds the 4 digit number, minus 1, into the second box, and moves focus to the third contrrol on the page. The way I am doing this is by having: txtBox1...

Sorry for posting this in the General forum, but as this directly relates to both Reports and Queries, I figured this was preferable to posting the samer thing twice in other forums. OK, here is the problem, I just cannot seem to get my head around how to design a query and then how to produce...

I am tryign to create a query but just cannot even get my head around how to design it, here is what I want. I have the following tables and fields being used for this query: tblMain.COTRound tblMain.DayID tblMain.StateID tblMain.ProgramID tblPrograms.ID tblPrograms.ProgramName...

In one of my functions I want to check if a query returns any rows, if so, keep going, but if not, skip a certain piece of code and then continue on. At the moment, I can get it to keep going if the row exists with: ub = rst.RecordCount If ub <> 0 Then ~ Code to be executed ~ End If ~ More...

One more quick question. I have a form that contains 1 textbox and two combo boxes. All I need to do is pass the values of those three fields to three hidden text boxes on a second form, which is opened when the first form closes. Now I thought this would be simply a matter of setting all...

Does anyone know how I can set the criteria of a query in design view to a public variable? Cannot find any info in the help documents. Access 97. Thanks guys,

Hi guys, this is my first post here, hope someone can understand my babbling and offer some advice :D OK, well I am setting up an Access 97 database at work, and have little to no training in the program, so most of my results end up being workarounds at best, so long as the database does as...