Automated Press Adverts - Via The Use Of A Database?
Jan 31, 2006
Hi I really hope some one can help me out here.
Here the outline of the situation. Every Friday evening I get sent a load of press adverts, which I have to put on the Intranet. This will involve detaching the ads, renaming them, adding them to the site with the Name of the paper, the date, and the organisation they belong to. What I want to know is if there is a more automated way of doing this. I was thinking weather I could detach and drop the ads into a folder and get a Access database connection to the press ads page. Which in-turn would allow me to insert the ads for the last seven days, yet keep a account of all ads which can be a called upon, via perhaps the use of a search function. This is just one idea I have had, are there any other ways I could make this mundane job easier?..
I have a multi-layered question regarding setting up an access database for fluid samples sent in by a customer.
Ideal Setup: The database would prompt me for the Sample ID number which is a unique code we give to each sample. It would then prompt me for the customer name and if given an existing customer name it would pull up all the contact information for the customer. It would then prompt me for the machine ID# that the sample came from, from which it will pull up the data from 10 previous reports and place into the current report.
I would then input the current data for the sample after analyzing it. I then have an automated control to convert the report to a .pdf file and send it via outlook. It would also be nice if the report was uploaded onto a website that the customer could access, but this is a whole different issue.
Is this setup possible with Access 03 and if so is it even remotely possible for a newbie like me to create? Additionally, what would the time investment be for a project like this for a beginner? Are there any other more effecients ways or programs to accomplish this level of automation?
Hi, I've read a few posts regarding removing the facility of the F11, open Db window, but is there a way to capture if someone presses F11? I have a few people (users) who think they know a thing or two about Access and I'd like to know if/ when they're accessing the Db window.
I was hoping for the ASCI code or similar for the F11 key!? Thanks Matt
Code: Private Sub Lista0_KeyPress(KeyAscii As Integer) Dim strSQL As String Dim db As DAO.Database If KeyAscii = 50 Then strSQL = "UPDATE tblZlecenia SET Priorytet = " & "7" & " WHERE ID_Zlecenia='" & Me.Lista0 & "'" CurrentDb.Execute strSQL End If End Sub
When I press button "2" on my keyboard, my code is working (it's ok) but except this, changing selection on my list, to position where bound column starting from "2" character. What I should do, to not change possition on my list?
Hi, I need help with listbox problem: I made a listbox contains peoples name from A to Z. I want to sort it via A to Z button press. It's similar with customer phone list form in Northwind.mdb sample, due to my limited knowledge, I can't replicate it using listbox.
As above, I've noticed that it will only trigger if there are no textboxes on the form with a higher tab index than the control the keyascii is set for. Any ideas why, or what I'm doing wrong?
I've found this a lot and never bothered trying to find a solution till now. :p
if its possible to have a button that after clicking it, it doesn't show certain records. Reason being I have a "shows" for each month on our personal site and amazon, and we've been selling on those for about 2 years, and I have a "show" for each month. But, that quickly clutters up the list box. Any way to create a button the (after typing in the name) it doesnt show only those record(s)?
I'm sure this is really simple... apologies, but a search hasn't thrown up any clues.
I have a table with Invoice Value, and Commission Value in it. On the associated form I enter the Invoice Value, and also the Commisison value [which 99% of the time is set at 20%.
I am trying to make a button which, when pressed, enters the calculated commission in the form field (and underlying table) - I realise this could be in the 'On Click' property on the form, but in VBA I am after something like.
Private Sub btnCommCalc_Click() tblSales.Commission = tblSales.Invoice * 0.2 End Sub
Could someone help me with the syntax? (I can then move on to using a variable, rather than hard-wiring the 20% ;-)
i want that when i press the space key on my keyboard oi will exit from the form. i searched on the interne t but i couldn't find the proper one. I don't know exactly what i have to write in vba.
what I have is a password entry popup, it's very simple and there is only one password, so it's coded into the form.There is an unbound text box for the password, set with the password input mask.An OK button and an Exit button.The OK button has this code on the 'On Click'
Code: Private Sub cmdOK_Click() If IsNull(passwordentry) Then passwordentry = "*" End If
[code]...
Now what I want it to do is automatically move to the OK button when the correct password is entered, so that you can just hit Enter.Currently you either have to press the OK button with your mouse, or hit Enter to move to the OK button and then press Enter again to activate it.
In the form1 , I have a listbox1 with 2 columns. The values get added in the listbox using vba. Now I want to Edit the listbox values in case user enters something wrong. So when the user selects a listbox item and then EDIT button then form2 gets opened. And the textbox1 of it stores column1 of listbox1 value and textbox2 stores column 2 of listbox1 value. So the user canb make changes in the textbox values and then press SAVE button . Now I want the code that will make those changes in listbox1 of form1 and unload form2 then.
I'm trying to run a make table query, and I'd like to automate it. Is there any way I can do this through a script so that I don't have to answer Yes/No to any of the pop ups? I turned off the notifications, but I still get the odd pop up.
I have a query run that gives me a list of records that I view on a continuos form. What I want is to press a button and run a macro/Append Query to add a Single Summary record to another table.
For example my query spits out this data
Part # Quantity Serial Number GO2 1 123 GO2 2 456 GO2 2 789
What I'm looking to get is
Part Number Total Quantity Serial Number 1 Serial Number 2 .. GO2 5 123 456
I'm stuck on a couple of things.
1. Getting a new single row to append. 2. Getting Serial Numbers from several records to save on to a single record.
After much frustration and hair pulling I have managed to get the code below to work.. It prints out reports from access one at a time cycling through the list of schools in our county. My question is that I would like to save each report with a filename eg KS1_3000_version1.pdf where 3000 is the unique school ID.
So my question is how can I get the code/acrobat to save my file in a desired location with a pre-specified filename?
this would make the whole process a real click of a button! I know it is possible because we have a national database that does the same thing.. but I cannot crack the backend to see the code
bah!
thanks in advance
john
***********
Option Compare Database
Private Sub Command1_Click() Dim repQuery As QueryDef Dim dBase As Database Dim rsRep As DAO.Recordset Dim strrep As String Dim data1 As String
Set dBase = CurrentDb() Set repQuery = dBase.QueryDefs("john_test_ks1") Set rsRep = CurrentDb.OpenRecordset("2_KS1_Performance_review_report")
Do While Not rsRep.EOF data1 = rsRep.Fields("ESTAB_FK").Value repQuery.sql = "SELECT SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA.DFES, * FROM 2_KS1_Performance_review_report INNER JOIN SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA ON [2_KS1_Performance_review_report].ESTAB_FK = SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA.DFES WHERE ((([2_KS1_Performance_review_report].ESTAB_FK)= " & data1 & "));" repQuery.Close DoCmd.OpenReport "john_test_KS1_report" DoCmd.Close acReport, "john_test_KS1_report" MsgBox "done" rsRep.MoveNext Loop
I want to automate the file transfer from a remote site to my pc over a WAN. Can anyone please suggest an industry standard secure file transfer tool for a windows environment?
I am looking for an industry accepted, more secure than traditional FTP. Thanks!
the pieces of the puzzle are coming together, I am near completion of my database now...but have 1 or 2 more final questions!
Can today's date in the YYMMDD format be automatically entered in a table's column when I import a .csv file into access?? - this would obviously change daily and as such the table would need to be updated with the YYMMDD date when I carry out the daily import of the .csv file .
it will need to be fixed length of 6 characters so I can create my exported file.
Thanks again for any help! I have not been using Access for too long, but with the support from these forums, I am developing a greater understanding every passing minute! :)
Hi All. I hope this is in the right forum. This is an example of the sort of thing that I am trying to acheive.
I am building a database to connect rooms. i.e (Building1, Floor1, Room1) connected to (Building2, Floor2, Room2)
I have 2 forms (frmBuilding) to add building names and (frmFloor) to add floor numbers. On the other form (frmConnect) , I have the current location (Building and Floor) and I have a subform in datasheet view. I have 2 combo box's (both with a query as the source), one to pick a building I added in frm building, and the other to pick a floor I added in frmfloor. I also have a text box, where I add the room number.
This is would like to do if possible.
Try and automate the adding of records, so, for example, if I am adding records of (Building1, Floor1, Room1), (Building1, Floor1, Room2), (Building1, Floor1, Room3) to the subform, it will ask me how many rooms I want to connect, in this case 3, and then add them, keeping the building and floor numbers the same. (I think I am explaining this more complicated than it is, sorry!!)
Can someone point me in the right direction? I have been playing about with queries.....is this correct? Any help is greatly appreciated.
Hello, I have a table which identifies my database users with the following fields:
INITIALS USER TITLE
I than have another table named MASTER with two fields named USER and TITLE. The field user, get it's data from the first table INITIALS. I would like that the field TITLE would be updated with the users TITLE once it is entered.
I know how to do this with a form (I place in a txt box =[USER].[Column](2) but have noticed that it only displays the info but not actually stores it into the field.
Is there a way I can do this directly from the table so that I can remove the TITLE control from my form? Thanks.
I have set up a process to automatically email reports from MS Access 2006. Everything would would perfectly except that when the process runs, a messagbox pops up stating that 'an unknown prgram is trying to send an email on your behalf'. Before the email is sent you have to click on the button to allow sending. I need this program to run very early in the morning when no one is around to click the button.
I have tried several things to get a round this by digitally signing my Access project and setting up certificates in outlook but nothing has worked.
Is there any way around this without lowering my security level, my antivirus or antispyware software?
Hello, I have been learning how to use Ms Access in order to design my own Database, I have done quiet a bit but i found myself kind of stuck witth the following issue. My question is pretty simple (I think…) Please, can someone help me? :o
I need a field that update itself automatically for each record. For example, if I have 2 initial fields called [Stock balance] and [Quantity delivered]; I need to find a way to have the [Stock balance] updating itself just by entering a value for [Quantity delivered] where [Stock balance (actual record)] = [Stock balance (previous record)] – [Quantity delivered]
I could create a third field Called [Quantity left] with [Quantity left (actual record)] = [Stock balance (previous record)] and [Stock balance] = [Quantity left]-[Quantity delivered]
but it doesn’t seem right to create a third field that is equal to an other field just with one record difference.
