Hi all! I am looking for some help in how to get a form to open just once on the first launch of the database. This information is the company information of the one using the software. I have a button that one can click if they want to edit or add this information later. Thanks for your help in advance.
:confused:
hi guys, here is the situation.
I have 3 forms:
1- editpopsubform where the info comes from a select statement.
2- editPoplist , which has the form 1 as a subform
3- editpop, a form which allows the user to edit a record selected in the poplist form.
The idea is to open the editpoplist form, where a list of records appears. Once a record is double clicking in the code number, the editpop form is open showing all the details for that particular record.
the code number in the editpop from is assigned as per the following:
=[forms]![editpoplist]![editpopsubform]!ifsnumber
Problem: when i double click in the code number the following error appears...
"run-time error 2501 . the open form action was cancelled"
any clue?
thx max.
I have a form, which is comprised of a sub form, and some of the text box controls sided with a button, and the event had been written to the button.
Now, to give a note on how had the sub form had been created is firstly taking a clone of the "Payments" table and using it as a datasheet, and then create a sub form in the form, it works fine
My goal is to have one form which will be used to launch any of my reports. I'd like to be able to group my reports (Customer Service, Accounting, etc.).
There used to be a great sample of this on the forum but I can't locate it...perhaps we lost it in the hack.
So my question is what is the best way to create a form that will allow the user to select from a list of all available reports?
Thanks everyone.
I have a fairly simple report which lists rows from one table with a little bit of logic. At the end of each row, I want an action button, which when you click it, goes to a form with the correct ItemID for that row.I tried the VBA code like this on the View button on click method:
DoCmd.OpenForm "CreateCAF", , , "[ItemID] = " & Me.ItemID
Of course, what happens is it opens the form CreateCAF with the first ItemID in the report, regardless of which row you click on. I want it to pick up the ItemId of that row.
Still working on an meeting registration app in Access. I have a Main menu which contains buttons that allow search by Name, Phone Number, or Account Number. We are using barcode scanners if they have a registration card.
Currently I have an account button which pops up a query prompt window and when they scan the code it fills the prompt with their account number and a carriage return, pulling up an account registration form with their info.
What I would like to do is from the main form, if a barcode is scanned, to automatically lauch the account form passing the scanned account number.
I have a 2007 back-end db on a network share and around 15 regular users who access it through their own front-end db/interface. One user on Windows 7 is able to launch and use his front-end copy fine except when he goes to launch one form for data entry.
This form clocks and freezes the entire application. I sat with him and was able to determine that the issue is that the form_load code is never running. He clicks on the button to launch the form (done in vba) and the code never runs. If he opens the form in design view first then changes to form view, the code runs fine and there are no issues. This is his present work-around, but I had to give him an unlocked FE copy to pull it off (not ideal!).
I tried this with him on different PCs, with different front-end copies, and even in the back-end copy. Same result each time. None of the other users have this issue, and he can replicate this issue on different PCs. I'm at a loss for what might be causing this since it really seems so user-specific.
I am working on an access database that is a meeting registration database.You can search by Name, Phone, or Account Number and then mark the person as registered.
What I am trying to create is an enhanced search by name. I have created a simple form in datasheet format so that if I search by last name I will probably get a list of names with that last name.I want to be able to select the name I want, either by double click or highlite and press a button, and then it launches my form that I created for the account lookup / registration.The account form runs a query that prompts for an account number and displays that account.
how to launch the second form passing the selected record's account number.
I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.
Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub
Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.
I have created a database then saved it to my computer.
Now while I am trying to open MS ACCESS in my computer I am getting an error message -
"This file may not be safe if it contains that was intended to harm your computer.
Do you want to open this file or cancel the operation?"
Giving the options - 'CANCEL' 'OPEN' 'MORE INFO'
How can I by pass this dialog box?
Hi,
Not sure if this is not a stupid question, but when I try to open two forms with controls that have the same underlying control source, I encounter a message that say "the table is locked and cannot be malnipulated pregrammatically", or "the table you tried to open is being used, please wait a while before trying again." Is there anyway around it at all?
Niroth
I have the following code, which works the way I want it to when I click the button the first time. However, if I close out the excel and click the button again, it errors at the line "ActiveWorkbook.Worksheets("Ref").UnProtect", with the message "Run-time error '91', Object variable or With block variable not set". I can not figure this out, why in the world does it work the first time, but not the second???
Private Sub cmdReport_Click()
Dim path As String
Dim XL As Object
Dim oBook As Excel.Workbook
Dim pic As Excel.Shape
Set XL = CreateObject("Excel.Application")
[code]...
I work on a pre-created Access database, and the other day I was working on it, and was trying to export something to Excel to sort it and do some Pivot analysis.
Anyway, I must have pressed something, because now every time I open the database, rather than saying "record 1 of 20463" and showing the data from record 1, it shows "record 1 of 1" and all the data fields are blank. If I go to "Records" and "Show All Records" they'll all come up, but I don't want to have to do that every time, and as I import and export all the time, I'm worried that the next time I try it it'll mess up the years of data I have.
Can I open an email to send filling in the To or the BCC field but maintain my outlook signature page???
Currently I open email, but my signiture is missing???
Thanks
I have a command button on a form, and on its onClick event i have placed the following statement in order to open a specific word document:
Call Shell("C:Program FilesMicrosoft OfficeOffice 10Winword.exe C:TempTest.doc", vbMaximizedFocus)
This works fine, however I noticed that if the path for the specific document contains a space, it does not open up successfully but i get a msgbox saying "the document name or path are not valid"
Any suggestions please ?
Thank You
Hello All,
I am new to this board and have a question about your opinion on creating an Access project that will be a project launch calendar for an organization. Basically, there are numerous projects with start and end dates and they need to be tracked every month and Gantt chart type reports are created that how their current status and if they have slipped or not. It is done in Excel now, where are set of people gather information about different sets of projects and at month's end compiles them into one Excel sheet which is then used as the basis for generating some reports through Mail merge and also manual Gantt charts in power point.
So, the idea is to port this system to Access where data is continuosly fed by the users through the month and then at month's end reports generated that are similar to what is produced manually now. My basic questions are:
1) What do you suggest regarding the process of having multiple users interact with Access to feed in data throughout the month, i.e. can this be done concurrently or is there a best practices process of having multiple users interact with the system without disturbing each others work?
2) Is there a sample project or technique someone can suggest that enables production of Gantt chart type or MS Project type visual timeline reports from the underlying data?
Will appreciate any pointers. Apologize to folks for whom all this is very basic.
Thank you
Hi
How do you launch a text file using a button in VBA?
I want to click on a button to open a log file - I would actually like to open a dialog box that starts up in a particular directory (eg C:logfile) - the user can then double click on any required txt file which then opens in notepad.
Thanks
What is the simplest (script) way of opening a .mdb file from a simple VB appliaction that I have made i.e by clicking a command button that says "Click this button to open XXX.mdb"
View 3 Replies View RelatedHello all
I have fell into Data Access Pages (yes, it hurt :p ), and have absolutely no knowledge of HTML or Javascript (though fairly competent with vb), so please bear with me!
When you are using normal forms in Access, you can launch a separate form from a command button, and bring up a record based on a value in a combo box - for example, Form A has a combobox1, and when cmdbutton1 is pressed it launches Form B and displays the appropriate record, using the criteria of combobox1.
My question is, is there a way to duplicate this functionality when using DAP?
Cheers for any insight..................
I have a database that stores information for lab testing. Each time a tech does a "step" in the test process he logs it in the table, using an input form. There are different categories, for example preparation, testing, analysis, etc, and each of those steps take time. I have the form autopopulate the date and time with NOW() evertime the form is updated. What i want to do is calculate the time it takes to do each in days. I can easily get how many days it was from now since they logged the test, =NOW()-TestDateTime. What I want to do is get the number of days it took to do each step, ie the number of days between each event. Is there a way to do this?
View 3 Replies View RelatedI would like to be able to have a button that my firm's legal assistants can click which will automatically popup the folder on the server where the client's documents are stored. What is the easiest way to write this?
View 3 Replies View RelatedI have 10 small databases. At present, I have another database which serves as a platform to launch the 10 databases. I have a graphic for each database and posted an Event Procedure for each graphic to launch the respective database. For example ...
Dim accapp As Access.Application
Set accapp = New Access.Application
accapp.OpenCurrentDatabase ("M:MPFMPF_Mgmt_Info_SystemSignInPlusSignInPlu s.accdb")
accapp.Visible = True
Is this the best way to centrally locate and launch multiple databases or is there are smarter way?
I have been searching the web for a solution to this problem. I have created a scheduled task on Windows 7 to automatically run a macro from a command line, however, it seems to only run when the user is logged onto the machine. Is there a way to run Access without the interactive logon? I would rather not leave the machine logged in with this account, but if that is the only solution, so be it.
View 7 Replies View RelatedCurrently running Access 2010.
I have a small database where we enter audit log data. In my add add screen from the switchboard, one of the fields is the user the audit is assigned to. So that our group wouldn't be typing their names a bunch of different ways I created a reference table called "Ref Data 005 - Contact Name". So i pre-populate the Contact Names such that they will be more consistent.
The add works perfectly. I built all my screens using the forms wizards.
Now for the modify routine. If the user wants to go in an modify one of the other data elements, I force them in the wizard to do this modify by choosing thier name. Therefore, when i built this screen using the wizard I reference the "ref table" mentioned above. I then throw open another form displaying all of the fields based on the records that it finds for that user when they choose the name from the Ref data 005 table. Hope that makes sense. Ie.. they choose the records they want to possibly modify by first choosing their name from the ref table.
It correctly pulls the records for whatever user you choose. However, when you make the update and save, it is changing the Ref table name as well.
So for example if three users were in my ref as :
bill
joe
john
And you launch the form, lets say joe shows up in the list, when i change it to bill to retrieve bill's records , it will do that but when i make the change, then Joe is changed to bill in the reference table.
I tried to dynamically set image OnClick property to function with couple of attributes. Everything works well, but... it launches the function automatically without any mouse click! What is causing this? I want to execute the function only on the result of mouse click.
Piece of code:
Forms!Form1.Controls("Image" & i).OnClick = fclick(PiltID)
Private Function fclick(u)
DoCmd.OpenForm "Form2"
Forms!Form2.Image0.Picture = u
End Function
I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.
The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.
The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.