Search results

Hi, I am trying to get exel to copy data from several worksheets and place the data in another sheet. In this case there are 2 parts. I want to copy data from all of the sheets that begin with stdy based on the following I want to copy the data in cells A:H based on the value in cell G and...

I am trying to use DMax to sort out some number issues i have. Here is what i want to do. I have a field (Text) made up of a 4 letter code (AAAA) then a number. WHat i want to do is grab the highest number from this. where the code matches what is in a text box. I have got the following...

Hi all, I have a form that i use for data input, I have limited all of the menu's how ever the print option is still available. This leads to muppet users printing out the form and using it. There is a print button on the form that prints a report out that lays out the form into a useable item...

Hi all, Sorry if this has been posted elsewhere but i can't seem to find a solution. The problem: I have a report that prints exactly onto 2 pages (designed as a booklet) this prints fine on my computer and also many others. However on a few computers it prints blank pages inbetween. I know...

I am sure this is a monday morning problem for me. I have search and tried to implement what i have found but as far as I can tell that is what i am already doing. Here is the situation I have a form with a command button to open a report that is identical to the form for printing. (all the...

I have a report that list clients that are about to enter a clinic ... this report is printed off and given to the advisor at the clinic. The problem is that people just have a habit of turning up when they are not booked in. So ... what i need to do is have a couple of blank boxes immediatly...

Can anyone tell me the code needed to open a different database. Basically i just need to run this from a command button so that the users can open a different database. i have tried the Call Shell("C:\test\play.mdb", 1) but i assume that it only works on exe files or something because i get...

Hi all, I am trying to get my database to do an archive ... the actual archive bit of the database works fine so no probs there. The problems begins when i am trying to tell the user what is happening. i have this code. Dim DateForArchive As Date Dim NumberForArchive As Integer...

I am using some code that hides the access screen itself eg Makes it look like a stand alone program. This code relies on the forms etc being pop-up so that they can be seen. This bit of it works and look fantastic BUT !!! The problem i have is that i can't preview my reports as i would like...

Hi all, I am currently trying to get a full list of GP's and practices in our local area together so that in a form you can use cascading combo boxes to select a GP name and from that select a surgery that the GP is at. That bit is straight forward but after looking at it i am sure that there...

Hi there. I am using a parameter query based on a form BUT i can't seem to get it to refer to a specific column. If i have the combo box limited to 1 column then it works fine as i don't need to reference the column property. So what i need to do is reference the combo.column(1). I know...

Not really sure if this is possible but here goes I need to place the results of a simple select query into an array. Does anyone know if this is possible ... and if it is how would I go about doing it?? Steve

Hi there. I am trying to use an SQL query in a report but i can't seem to get it to work. The query itself works but i can't seem to get it to work as i put it into the string. The problem is getting the correct number of " in the format statements. Any help please!!! strSQL = "SELECT...

I have a strange problem (strange to me) with opening a report. The report is based on 2 tables. (1main 1 sub) It is opened from a form using DoCmd.OpenReport "rptVenue", acViewPreview, , "VenueID = " & [VenueID] This works fine if both the main table and the sub table have data but if...

SQL in a form - Problems I am using an SQL query to update a listbox in my form but as the form loads i get an error that i don't understand. I have created a query that seems to work but when i use the sql in the form it doesn't :confused: :confused: (In frmSearch) I have attached it in 97...

find record problem I am using a simple search to goto specific records but. Dim rs As Object Set rs = Me.RecordsetClone rs.FindFirst "[IDCode] = " & "'" & strPersonIDSelect & "'" Me.Bookmark = rs.Bookmark I have a couple of records with a " ' " in them and it...

I am sure that this is fairly simple but nothing ever is with a listbox. I have a cmd button that runs some code but i need it to check to see if there is something selected in the listbox first. The listbox is set to MultiSelect - None Thanks for any help Steve

Hi there I have a crosstab ... but what i need it to do is to display a 0 instead of leaving the fields blank. I think that i need to use the Nz function but i am not sure as how to use it. Any help would be extremely grateful. Steve

Hi there. I have what i think is a simple question but it has stumped me. I am using the docmd.CopyObject DoCmd.CopyObject "path To DataBase", "New TableName", acTable, "Source Table Name" What i want to do is set the "path to database" to the current directory. because the databases can be...

Help - I have a combo box that runs a simple search and also has an add facility on the not in list event. The problem is that it seems to be adding 2 rows into the combo box instead of just once but i can't figure out why it adds the second row. It is very hard to explain what is...