Loading Db Tables
Oct 26, 2006
Hi,
I need help urgently. I am currently receiving files in .txt format through ftp which then reside in the same network folder as my Access Db. All the tables have been designed to read the data in. I'll be receiving these files on a daily basis. My idea is to automate this process. So, I would like to delete the existing data from the tables and then load the new set at a particular time everyday. Again, data comes in a .txt format through ftp. Please let me if this could be done and how. Thank you.
Arvind
View Replies
ADVERTISEMENT
Jul 8, 2014
I have tried on different forms using more than a few different methods to make recordsets happen and to no avail. My current reason for needing to use recordsets is because I am loading a form with information from different tables. Instead of using multiple DLookups, opening the recordset only looks for the information once, speeding up the load time on the form.
Code:
Dim Rs As Dao.Recordset
Set Rs = CurrentDb.OpenRecordset("PreviousTRRetrieval2Query")
If Rs.RecordCount > 0 Then
ProjectNumber = Rs!ID
Agency = Rs!WitnessAgency
FileNumber = Rs!FileNumber
That is the start of my code and I keep getting an error, 3061 Too Few Parameters. Expected 1. Now when I run the query I get the results I desire, which is all the information I need at this particular junction. I am using Access 2010. Why I may not be returning any results for my recordset when the PreviousTRRetrival2Query returns results on its own.
View 12 Replies
View Related
May 9, 2005
i have a form, in which two of the controls on the form, are unbound image controls, which display linked images. Now i have a button, which when both images have been displayed successfully, i would like to set the enabled property of this button to true.
How can i detect, that an image has ended up linking and is now fully displayed ?
Thank You
View 1 Replies
View Related
Oct 31, 2005
Hey,
I am updating a switchboard from someone elses work.
I get the error on other peoples computers (but not my own) that there is an "error loading DLL" and the I get "The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that <database> can't find.
* The expression maay not result in the name of a macro, the name of a user-defined function or [Event Procedure].
* There may have been an error evaulating the function, event, or macro"
I am including a before and after of the db as attached. (-new is the new one)
Again the form opens perfectly on my computer for both but not for anyone else. The error thrown is included as well as the jpg
HELP NEEDED AND APPRECIATED!
View 2 Replies
View Related
Apr 18, 2008
Hi, im using a .mdb Database in Access 2003 and i got it stored on my network server.
Now i have this problem:
If i start the Database on one specific computer, the main menu (the first page that pops up at loading) is not showing correctly
Other Forms are accessible through the manager-list
Meaning, that background and picture in background are showing correctly, but none of my buttons are there.
All i get is one single small click-button and a "1" next to it....
Button not having effect at all..
So my questions :
a) why is this problem only showing on ONE and only one computer? On other computers the database is just doing fine.
b) what IS the nature of the problem
c) how to fix it?
Many thanx for a quick reply..
View 2 Replies
View Related
Jun 27, 2014
I have a Splash Screen type deal that loads after the user logs in I wanted to know if there was a way that I could add a Loading Bar that would say different things like Are you having a nice day?
View 14 Replies
View Related
Apr 11, 2006
Hi all,
I encountered some weird symptons with my Access forms. I am using the form to display images(done by setting the OnCurrent and After Update property).
When my PC is just powered on, and i try to load say form "ENGLISH". Form "ENGLISH" will appear, but the focus will switch in between form ENGLISH and the MS ACCESS program window. This action will onli settle down after abt 10 secs.
When the ENGLISH form is loaded, i will attempt to switch from one record to another, but the same thing occurs again. IT will load/refresh for abt 10seconds, with the focus toggling btwn ENGLISH FORM n MS Access.. IN addition, it opens a second copy of FORM "ENGLISH" in the background as can be seen on my taskbar. When i close my 1st form ENGLISH and i attempt to close the 2nd FORM tat is appearing on the taskbar, there will be an error msg, English : MSACCESS.EXE-Application Error, Instruction at....(refer to the attached jpeg file for detailed error location)
Y is it tat this weird behaviour onli applies to the forms tat are used to display images but not those normal forms tat contains of purely text?
The entire behaviour will be eliminated after i close MS access, and reload the DB abt twice.....
View 3 Replies
View Related
Apr 14, 2006
Hello All
I have a list box that displays the names of customers who are allowed to hire DVDs.
I would like to highlight a customer and show all the relevant customer data on a separate form, not have the list box on the same form that displays the customer's data.
Regards
Terence
London
View 2 Replies
View Related
Nov 13, 2007
Hi
I am trying to get a blank ribbon to be in place when a user opens my application. I have an Adp linked to SQL Server. If I create a table in SQL Server named ribbons and have the app read the data in that table in the AutoExec macro (this runs the code that reads the data) then assign the new ribbon to Application.LoadCustomUI RS("RibbonName").Value, RS("RibbonXml").Value it works and the blank ribbon is displayed. The problem is that this is no use because if the adp is not connected to the database on startup it causes an error as no connection has been established.
Instead I have put exactly the same xml file into a module but this does not have the same affect even though I call the same Application.LoadCustomUI method. I havent really done anything different except change how the xml is found. The problem with this method is it just pops the new ribbon into the list of available ribbons so then the user would have to choose the ribbon, shut down and restart, that is no use.
Has anybody got any idea what can be done about this? I will post the code below.
Thank you for any advice on what can be done.
Paul
First method (which works but is no good for distributing the app)
Autoexec calls the following
Public Function LoadRibbons()
Dim RS As Recordset
Set RS = CurrentProject.Connection.Execute("SELECT Ribbons.RibbonName, Ribbons.RibbonXML FROM RIBBONS")
If Not RS.BOF Then
Application.LoadCustomUI RS("RibbonName").Value, RS("RibbonXml").Value
End If
RS.Close
Set RS = Nothing
End Function
but using the following and calling it in autoexec just puts the ribbon in the list and doesnt use it
Function CreateRibbon()
Dim xml As String
xml = _
"<customUI xmlns=""http://schemas.microsoft.com/office/2006/01/customui"">" & vbCrLf & _
" <ribbon startFromScratch=""true"">" & vbCrLf & _
" <officeMenu>" & vbCrLf & _
" <button idMso=""FileCompactAndRepairDatabase"" visible=""false""/>" & vbCrLf & _
" <button idMso=""FileOpenDatabase"" visible=""false""/>" & vbCrLf & _
" <button idMso=""FileNewDatabase"" visible=""false""/>" & vbCrLf & _
" <splitButton idMso=""FileSaveAsMenuAccess"" visible=""false""/>" & vbCrLf & _
" </officeMenu>" & vbCrLf & _
" </ribbon>" & vbCrLf & _
"</customUI>"
Application.LoadCustomUI "BlankRibbon", xml
End Function
View 1 Replies
View Related
Mar 9, 2008
Hi,
what is the best way to load or unload subforms? currently, i have the subforms within my form and code will change it visible and invisible but it would be better i think if they could be loaded or unloaded as i iahve existing code in the forms that all needs to be written.
( i originally had the subforms as separate forms that opened as a single form ).
can you load / unload subforms on a form as normal forms?
regs,
NS
View 8 Replies
View Related
Jan 24, 2005
I am looking for a way to automate the clearing of tables and re-loading of data from txt files. Can someone point me in the right direction?
View 4 Replies
View Related
Jun 16, 2005
If I have a tab control in a form, with a form on each tab, will the data from all the tab's forms have to be loaded when I open the 'host' (don't know what to call it) form?
I can't tell if the load time is increased, as there isn't much data there yet, so it's pretty much instant anyway...
View 7 Replies
View Related
Aug 8, 2006
Hi.
I am running a form on top of a query with around 1500 records in it. The query mostly uses tables that are joined with referential integrity.
The form has buttons and conditional formatting.
It was fine until today, when suddenly the form has stopped loading properly. It looks all fragmented on the screen and I have to scroll down and scroll back up again for it to look right.
I have searched everywhere to find out what is causing this and how it can be fixed, but no luck yet. Can you help?
Thanks.
View 1 Replies
View Related
Aug 23, 2006
hi... I have a form containing 120 subforms...
the form will be loaded depending on the user...
i name my subforms in sequence that is: loadA1, loadA2, loadA3,....
to load a form I just use the code: me.loadA3.sourceobject = "FormName"
and then I make a counter to keep track of which forms are loaded and which one to load next.. as they load in sequence..
the question is if its possible to write the above code in a string type or other way to make the code shorter...
For example my code is as follows: If ACount = 0 Then
Me.LoadA1.SourceObject = "TEMPCableName"
ElseIf ACount = 1 Then
Me.LoadA2.SourceObject = "TEMPCableName"
ElseIf ACount = 2 Then
Me.LoadA3.SourceObject = "TEMPCableName"
ElseIf ACount = 3 Then
Me.LoadA4.SourceObject = "TEMPCableName"
ElseIf ACount = 4 Then
Me.LoadA5.SourceObject = "TEMPCableName"
ElseIf ACount = 5 Then
Me.LoadA6.SourceObject = "TEMPCableName"
ElseIf ACount = 6 Then
Me.LoadA7.SourceObject = "TEMPCableName"
ElseIf ACount = 7 Then
Me.LoadA8.SourceObject = "TEMPCableName"
ElseIf ACount = 8 Then
Me.LoadA9.SourceObject = "TEMPCableName"
ElseIf ACount = 9 Then
Me.LoadA10.SourceObject = "TEMPCableName"
ElseIf ACount = 10 Then
Me.LoadA11.SourceObject = "TEMPCableName"
ElseIf ACount = 11 Then
Me.LoadA12.SourceObject = "TEMPCableName"
ElseIf ACount = 12 Then
Me.LoadA13.SourceObject = "TEMPCableName"
ElseIf ACount = 13 Then
Me.LoadA14.SourceObject = "TEMPCableName"
ElseIf ACount = 14 Then
Me.LoadA15.SourceObject = "TEMPCableName"
ElseIf ACount = 15 Then
Me.LoadA16.SourceObject = "TEMPCableName"
ElseIf ACount = 16 Then
Me.LoadA17.SourceObject = "TEMPCableName"
ElseIf ACount = 17 Then
Me.LoadA18.SourceObject = "TEMPCableName"
ElseIf ACount = 18 Then
Me.LoadA19.SourceObject = "TEMPCableName"
ElseIf ACount = 19 Then
Me.LoadA20.SourceObject = "TEMPCableName"
End If
If ACount < 19 Then
ACount = ACount + 1
ElseIf ACount < 0 Then
ACount = 0
Else
ACount = 20
End If
anyway to make it something like:
"me.loadA" & Acount & ".SourceObject = "TEMPCableName"
??
Thanks in advance
help is much appreciated
View 2 Replies
View Related
Dec 30, 2004
I have a player information form where a player picture is stored. When I first wrote the program I was able to upload a picture no problem from my computer, I had a crash and now when I try to load a picture it takes three times as long and all that shows in the picture window is the picture name. Did I lose a setting or a program during the crash? Hope this makes enough sense.
View 4 Replies
View Related
Jun 27, 2005
Hi every body. I wonder how i can generate and load a report when a button is clicked on access 2000 form. I be happy if some one show me an example.Thanks
View 1 Replies
View Related
May 21, 2013
We have access DB on a server accessed by 3 workstations. When we open the shortcut it opens a form. Few days ago we started getting this error: can't find project or library..Then this code opens in Microsoft Visual Basic
Code:
Function CheckCommandLine()
If Command <> "" Then
changeTableLinks Command
End If
[code]...
Link to the database is like this:"C:Program FilesOFFICE11MSACCESS.EXE" serverdbsci.mdb /cmd serverdbsci_data.mdb....We don't get this error on Access 2007.
View 3 Replies
View Related
Apr 24, 2006
Hi All.
I have look through the forum but can not find a solution to my problem.
I have a popup form set to "popup" and "modal" "frmJobBookOut" which passes data to a query "qryJobBookOut". In the query there is a field called "job_no" and I have set the criteria to reference the "frmJobBookOut" ** [forms]![frmJobBookout]![job_no] ** and a report "rptInvoice" based on the query "qryJobBookOuit". This all works fine.
The report loads with the popup "frmJobBookout" form still displayed. I know that the popup form is still displayed because I have the setting "modal" and until I click on the close button it will remain on screen.
Is there a way I can close the popup "frmJobBookOut" form after the report has loaded.
I have tried many ways but not the right way.
Many thanks if you can help.
Kind regards
View 2 Replies
View Related
Nov 24, 2007
I'm just getting familiar with Access and have been unable to solve the following problem and am hoping someone here could help. I have a lot (10,000s) of csv formatted files that I would like to import into a database. Each csv file corresponds to a new record in a table but the fields are arranged row-wise.
My problem is two fold. One, the fields are arranged in rows and not columns so when I try to use the "Get External Data -> Import" option to import a single file the columns and not the rows are read as fields. Two, even if they could be imported properly I have thousands of files I need to import so I would also need to automate the process, perhaps with a VB program.
Below is a sample of the csv file format: (the real files have over forty fields, and note the units column may sometimes be blank)
Field,Value,Units
name,Meta Particle,
speed,3.18,m/s^2
mass,0.001,kg
height,123,ft
width,81,meters
Is there an option in Access to import many identically formatted csv files and transpose them in the process? I would appreciate any ideas on how to load them into a table.
Thanks
jackiesushi
View 3 Replies
View Related
Sep 25, 2005
Hi All,
I am new to Access and looking for some help.
I have a query, which reads the combo box value and loads the result in Text box. It works fine when I load the Form.
Now here is the problem… If I select another values from combo box the query result remains the same (in text box). How do I make it work dynamically?
So when I select new value in combo box, the resulting query gets updated in textbox.
Thanks
View 3 Replies
View Related
Jun 22, 2006
Hi all,
I've a form with an image on each page which is linked (not embedded) to filenames from another table. When moving through the forms the time it takes to import the picture is relatively slow, is there any method or hack I could use to speed this up?
The code I'm using at the moment:
Private Sub Form_Current()
Dim Picture As String
On Error GoTo PictureError
Picture = Me.Clipping_UNC & Me.Clipping_File_Name
Forms!REPORT_Coverage_Clippings![Image].Picture = Picture
PictureError:
If Err.Number = 2220 Then
Forms!REPORT_Coverage_Clippings![Image].Picture = "m:setupimage.jpg"
Else
End If
End Sub
View 2 Replies
View Related
Jan 21, 2015
I have a report that summarizes the record content that is contained within a form (one report line per form record). If the user wishes to view a specific record on the form, he clicks on the report control that contains a numeric value that identifies the record on the form. I can get that to work with the following code:
Code:
DoCmd.OpenForm "AdmissionForm", acNormal, , "[Admission Number] = " & Me.Text0
where Admission Number is a control on the form and Text0 is the control on the report containing the admission number requested i.e. if the report control Text0 = 10, the form would open with the current record in which admission number = 10.
Problem is though, the form opens as "filtered" with only the one requested record (i.e. record number 1 of 1). What I would like is the unfiltered form to be opened with the requested Admission Number as the current record. I have tried DoCmd.GoToRecord but can't get it to work.
View 5 Replies
View Related
May 6, 2014
I have a RTE 94 happening due to a piece of code running on a subform current-event which looks at a text box on the parent form. I understand this is due to the order of loading of the forms initially and all works fine when moving to other records once all are opened. How can I overcome this happening on first opening?
I am thinking I need to set a counter on the subform on load event to say 1, then when the subform current-event fires add some code so if the counter is 1, then do nothing, if 0 then run the code. When the mainform opens reset the counter to 0, then requery the subform. The form will now see the counter is set to 0 for the rest of the time, so will then always run the code.
Not sure how to go about setting out the code as I guess there needs to be some form of Public variable involved?
View 4 Replies
View Related
Aug 8, 2014
I have a separate form in which I want to use as a loading screen for my users while the query loads on the other form. Now I can do this with text easy but not with a .gif..I have the loading form to
Code:
Private Sub Form_Timer()
DoCmd.Close acForm, "Loading Screen", acSaveNo
DoCmd.OpenForm "Form1", acNormal
But it just stops the .gif and then runs the query before opening Form1.
View 7 Replies
View Related
Feb 19, 2008
Hi all,
I have a query that is basically loading values from a open form.
Im using the format of Product: Form!form1!products to assign the value of products to product in my query... Now all this works with straight text, however this technique does not appear to work with dates or yes no check boxes. I have used the builder but still wont work with dates. any ideas? thanks
View 1 Replies
View Related
Oct 25, 2005
Hey firstly im at the end of the project ive spent months on and thats a MIS datase software. with all the bits and pieces and expert advise ive managed to learn a whole lot of things through this forum.
This is the problem i am having though;
i have a form that has two subforms embedded and since i have to use link tables because i placed the database file over a network somehow the loading seems to take forever, "it actually makes access inactive for about 50 seconds"
i would like to prevent the subforms from loading with the main form until after the main form is up and then i just click a button that makes both of them "appear" and load.
Can u advise. Much thanks.
:o
View 1 Replies
View Related
