Okay, it's all done now, totally completed you'll be pleased to know. I actually had to make the StrSQL_1 the global variable and put that into the report. All tested though and all working fine, thank you SO much for all the help.
What I meant when I said the string needed sutting up, I probably didn't articulate it very well, but what I meant was the string is a list of words seperated by commas, and the commas needed removing and...
Robertf987
Last Activity: Mar 20 '08, 02:29 AM
Joined: Feb 9 '07
Location: Norfolk, United Kingdom
-
Apologies if I'm being simple here, I'm going to try and explain.
The text string itself is created on the form. It's in a text box. It's a list of words seperated by commas, and a search is done using this criteria. You helped me with the VBA and SQL to do that. The code works fine, and brings up the results. Now I want to be able to print the results shown in the form in a report, as printing the form itself uses too much ink and...Leave a comment:
-
Okay, I'm going to be really annoying again and ask for yet more help. I'm having problems with applying the SQL code to the report.
I tried putting the code into the onOpen control of the report. Here's the code I used:
...Code:Private Sub Report_Open(Cancel As Integer) Dim varCriteria As Variant Dim intCounter As Integer Dim strSQL_1 As String Dim strBuildString As String strSQL_1
Leave a comment:
-
Okay, another question. This is the very last thing that needs doing on this database. I wasn't sure whether to start a new thread or add it to this one. As it's linked with my previous post I thought I would add it to here. I have that previous bit all working - the SQL is built into a macro and it makes all the data appear in a form. Next bit, probably easy again, but printing. I don't want to print the form, as it will use too much ink. I want...Leave a comment:
-
Thank you, all working fine now. I should have really known that... but I'm still learning (as we all are!).
Thanks for all your help, it's much appreciated. Will hopefully have this database implemented and in use next week, just got one more major function to do, then have to make it look professional (that's the stuff I'm good at =P, the easy stuff!)Leave a comment:
-
I'm actually replying to my own question, I found an old database with what I needed in it. I thought I'd put the answer on here just incase anybody else was searching for it.
I put the following code into the on click procedure for the list box:
...Code:If Len(Nz(Me!Subject.Value)) > 0 Then Me!Subject.Value = Me!Subject.Value & ", " & Me!List13.Value Else Me!Subject.Value =Leave a comment:
-
Thank you for your very quick response. I've tried to implement your code, but I am having a little trouble. At the end of your code, where it says Me.Recordsource = strsql_1, I need it to implement the sql on another form, not the current. Easy enough to do, I just replaced 'Me' with the form name. I thought that would work. But now on that line I get "Run-time error '424' Object Required".
I have two forms: one for doing...Leave a comment:
-
Doing an "Or" search using criteria from a text box
Hi,
Yet another thing I need help with I'm affraid. I'll first explain what I want, then I'll try to explain what I have. I'm using Microsoft Access 2000.
What I want is to be able to do a search, taking it's criteria fro a text box on a form. This bit is easy, done it a jazillion times. But I want it to be an "Or" search. If I type in it "Cakes, Cheese", I don't want it to bring up results that contain cakes... -
Copying values from a List Box into a Text Box
Hello,
I am creating a database in Microsoft Access 2000. It's to store books and other resources, like a library database (just to give you a bit of a background). I have a field called "Subject". It's a text field. In there, you manually type in the subject(s) that that book relates to, for example Sports, Health, Sex Education, Careers, Citizenship, etc. However, it's a bit inefficient to have to manually type in these words.... -
Fantastic, thank you very much, it works great. Can't thank you enough. A cookie for thee shall be thy reward. Thank you.Leave a comment:
-
Robertf987 started a topic How to bring up a list of tables in form view containing the word "backup"in AccessHow to bring up a list of tables in form view containing the word "backup"
Well, I think I've described what I want to do in the title here.
In the database, I have two main tables that contain the main data for the database. One for group expenditures, another for application details. I have a query for each of them to copy all the contents of the table into a new table, then delete all the data from the main table. I need to do this becasue once a year the data needs to be removed, ready for putting in... -
Hurrah! it works! When I first saw you said to put it in the OnTimer bit I did laugh, I already had stuff in the onTimer event. But just putting that to the end of the code, it all works absolutley fine. I'm sorry if all of this has seemed absolutley pointless, but I thank you both for being so patient and thank you for your help. Isn't it nice when something comes together?
(It may have been pointless and been easier to give up and scrap...Leave a comment:
-
Thanks loads Adezii. I set up the code linked to a form button, and it worked first time. I've made a few modifications to change the position and time, and it works reliably - from the form button. I can't seem to link the code to the form to get it to automatically run when the form loads for some reason. I've put it in OnCurrent, OnOpen, OnLoad, OnActivate, OnGotFocus, and none of them work. I've not changed the code, only copied and pasted. Put...Leave a comment:
-
Thanks laods for the help, and thanks more for being so patient!
I'll probarbly do the hourgass pointer. I just.... I wanted to do pretty stuff. And in what little experience I've had working with other people doing computing, hourglass pointers seem to get people frustrated just as much as nothing happening lol, I don't know why. I've done stuff like I taught networking to year 12's, desktop publishing to year 9's, basic databases and spreadsheets...Leave a comment:
-
Thanks both of you, Rabbit and Adezii. I'm sorry, I must seem so ignorant! I'm trying my best here. I have studied computing and believe it or not I got AA grade in my AVCE ICT. but I'm going to be a nurse, so... well... I'm not exactly an expert in all of this. But I do try.
Anyway, the progress bar I wanted wasn't a real progress bar really, but more a bit of an animation. There's this bit in the database where it does some stuff and hands...Leave a comment:
-
Progress Bar in Acces 2000
Okay, now then. I'm hoping somebody can help here, pretty please. I want to make a progress bar/indicator on a form. At first I was just going to insert an animated gif, but I've tried and remembered that you can't put an animated gif in there, it becomes static (I did find that out in year 10 at school, I should have known, but that's just me). I can't find an ActiveX control for a progress bat that works (and isn't it true that if you move the... -
Thanks loads for the help. I can get the delay to work for simple things like the text box, or to delay opening a form with the code you gave me. However, what I wanted it for, I can't get it to work. What I wanted was to make a progress bar. With a short delay, it would make the bar longer. I'd do it in a loop and then exit the loop once it reaches a certain length. I just want some animation to show that it is actually doing something. For some...Leave a comment:
-
Delay in VBA
Hi. I wonder if anybody can help me, I want to put a delay in my macro code. I want it to do the code, then wait say 500 miliseconds, then carry on. Can anybody help? Thanks. -
Thanks. i knew it would be simple, I should have known that. In my defence, I'd not slept properly in a few weeks, and I'd not slept at all that night. Also, I have the insanity/stupidity plea.
Thanks for your help though.
Now, if anybody can tell me where my glasses are, you get a chocolate brownie.Leave a comment:
-
Make Table Query - how to use the same query to make different tables
Hi, I'm a bit stuck with an access database. I'm using access 2000 if that's any help.
Right, it's 3:40am right now and I'm rather tired, but I *hope* this makes sense.
I have a table which contains the main data of the database, records of information of grants. For each financial year, the old data needs taking out of the table. Basically I have two options: delete the old data from the year before, or back it up in a new table. I'd...
No activity results to display
Leave a comment: