OK, I admit it, I'm lost. I searched and found the code to find out if a form is open, but I don't know how to use it. How do I "pass the from name to the function"? I keep getting mismatch errors
Please help!
Hi I am looking for help related to the “You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.” message when trying to change the design. I have done a lot of reading on this forum as well as googled the subject but have not found anything regarding my specific question. I find that there’s a whole lot of information regarding workgroup security and how to set up and troubleshoot. However, my needs are a bit more simple – I think :) We have a database that is shared among 5-6 users during a couple months out of the year. There are no log-on id’s required and everyone just opens the file and works as needed. Everything works fine; we have no problems with users changing or doing more than they are supposed to. Therefore, I don’t want to break anything by complicating matters…it works and we’re happy with it. The only annoyance is that during these couple months, someone has to make occasional changes to the database in design mode. Of course, we need everyone else out of the database so he can have exclusive access. This entails calling and/or running around asking those people to close the file and sometimes physically checking computers left unattended with the file open. So my question is: Is there any way to find out what users or workstations have the file open? This would make it so much simpler. All the users are on a Windows Server 2003 network and the files reside on a server. Perhaps this is more of a Windows question; I couldn’t think where else to post it! If anyone could point me in the right direction, I would really appreciate it. Thanks!
is there a way to find out who has a record open and send him message or someting similar?It happens from time to time that some one has a record open (selected in a form) and then is doing other things while the record is locked and a second person can't do nothing to the record.
I have a split db in use by about 20 people. Ocasionally a user opens a record that is already opened by some other user and if changes are made then he gets error 7878; "the data has changed error"
Is it possible to find out which records are actually being used/open/edited in a split db? All tables are related to the main key (CallID on table Contacts).
If it was possible to find out, I could have a label show up in the db record search form telling the user not to open that record.
Now he can get into the SFTP folder, but when he uses the shortcut, he gets an error stating Microsoft Access couldn't find the file ServerName.ACCT05.us.companyabbreviation.comSha reNameSFTPSFTPWorkgroup.mdw 1" "C:SFTP Database V2.1 FESFTP Database V2.1 FE.mdb" (Note the space and 1)
I created a new shortcut, and I was able to open the db using his target line, even though I can use the shorter one. For the new user, this still generates an error.
I am 2 years into my database. I am trying to find and open a folder based on a text box. The problem is folder could be in many sub folders which is hold on our J: drive.
To further complicate, the folder i am searching may not be exactly as the text box states.
EG. Text box could say 123456 however the folder could be called M123456 etc.
How do i locate a folder or subfolder and open it based on part of a text box...
I have been working on a simple data base for some time now (beginner level) and am still trying to improve it. I would like to do something but before that I would like to have your opinion to know if it is even possible?I have a query QryMainReport:
Start Date/Time End Date/Time Employee
At the moment this is what the format of my report looks like (I removed other unnecessary fields):
StartTime----------EndTime---------------Employee 12/06/2014 01:00--12/06/2014 03:00------John Smith 12/06/2014 04:00--12/06/2014 06:00------Jane Doe 13/06/2014 02:00--13/06/2014 05:00------John Smith 13/06/2014 08:00--13/06/2014 08:00------Jane Doe
I would like to do as a report. (Dates would always be from Sunday to Saturday). I am not sure it is possible to do that. I suppose first it would mean:I would have to do a query to separate the times from the dates?I would have to find a way for Access to find the unique dates and unique names?Does it mean I have to use cross tab queries?
A customer's name is SZEE. Seek him through the SName textbox with Find, and Access can't find him. (Same in the table.) Seek him with a wildcard Sz* and there he is.
I've tried it on another machine - also with Access2k - and it's the same.
Is it an Access quirk? Is there an answer? (The client asks why. Be good to be able to say.) Cheers.
I have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.
Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.
Problem: Visual Basic run-time error 7792: You can't open a subform when it is also open in Design view.
I have a subform with properties for SourceObject, LinkMasterFields, LinkChildFields changing according to objects and events in the master form.
The subform was bound to a query before which meant that the subform load event was happening as soon as the master form is loaded. I needed to restrict the subform loading until a certain point so I removed the SourceObject property for the masterform's subform. The subform on the master form is now Unbound.
(This is because I'm now running some code on the FormLoad event for the subform which needs to be restricted until the LinkMasterFields and LinkChild Fields properties have been assigned correctly otherwise it takes ages to load.)
Now I'm getting the above error. Obviously, i do not have the subform open anywhere in design view. No Visual Basic windows are open. I've closed the db, closed access, reopened it and clicked on nothing except the masterform. The error occurs when I raise the event in the master form which assigns the sourceobject property to the subform, i.e.
Me.sfmQryAllOV.SourceObject = "sfmQryAllOV"
Can anyone help me? I've googled this but finding no answers.
when i open a form i want to open another frm at the same time. i have a main form with some buttons in it. when i click on a button and a form opens then i am not able to click on a button to open other forms from the main form.
I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select all of the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from.
I want to open another form automatically when an initial form opens, both are non popup) I have tried open and load events - but still the calling form appears on top of the called form.
How do I get the two forms to open form 1 and then form 2?
Also I cannot use the timer event as this is doing something else.
I have noticed that on our network, certain people can open an Access db that is already open by another person, yet some cannot. We are using the same shortcut (to the mdb file) and all have the same windows read/write permissions.
Is there any way I can do a search that lets me put in a section of a part number and the part number be found? I only see how I can find the number if I put in the entire number.
I think this is fairly simple, but being as I haven't ever done it! I want to do a search to find all records less those called "Default". As I say I just cant think how to do it. Any help appreciated. Thanks
Im creating a database for college using MS access 2003.
I have 3 table that contain data and i am building form to allow a user to search for a particular customer. The customer ID in my customer table is an auto number.
I have a button on my form and it shows the find and replace box when pressed which is what i want but i then want it so that when a user types a customer ID number in to that find and replace box and it is an exact match for the find and replace box to auto close else show an Error message and allow the user to input another customer number,
Im sure there is macro code to do this so im asking if anyone knows or has any better ideas?
I have attempted for two days to following codes. I am still unable to get the way out. Would you give me a help?
The field fund_cd is a combo box of transaction table to look up reference table called fund_type. Here is the structure of fund_type:
fund_cd text 3
fund_desc text 50
fund_currency text 5
My needs are to pull both values of fund_cd and fund_currency to transaction table, so 1 combo box cannot meet my needs. As such, I write following codes to base on selected fund_cd to find appropriate value of fund_currency in fund_type.
From the code below, I meet the run-time error ‘3001’ and I am not sure can I finally get fund_currency using method of GetString.
I am trying to code a combo box control to find a record. This is incredibly simple but for some reason it won't work. Could you tell me what I am missing. I have put the following code in the after update of the control
Dim rs as Object Set rs= Me.Recordset.Clone rs.FindFirst "[ContestNo]='"&Me![Combo23] & "'" Me.Bookmark=rs.Bookmark
I don't get any errors but it won't work either...any ideas??
I have an unbound text box. I want the user to be able to type in all or part of a title for a movie. Hit the find button and then have a form open with entry's based on the text box.
Hello to all, Little new in Access i would like to know how to use the key to find directly to a record in a table. ie : i have a table where the primary key (unique) is a date, using VBA i would like to know the instruction to find directly the record 01/06/2004 for exemple. Thanks in advance. VINCENT
I realize this probably isn't the right place for this, but...how do I find all of my posts, whether I started a new post or responded to someone else's post?
I have a find command button that appears to call the find and replace message box. It should be a search for anything in my query. The code behind the button looks like the find and replace message box in the office suite. I believe I am trying to create a message box where you add an entry and it searches then lauches a subform with my entries.
When I checked the button it had the following code: Private Sub cmdFind_Click() On Error GoTo Err_cmdFind_Click
I read a few of the lookup queries but they only give me a drop down. Is there some way to customize the box comes up without altering all of Office or do I just sound lost.
Ok, so I made a registration website with FrontPage and published it. The registration page has several text boxes and a submit button. I was testing it out and entered a few dummy names. The conformation page popped up and said everything was ok. So I'm assuming the data successfully uploaded into the Access DB that I linked it to while in development.
My problem is when I go to the folder where the DB resides there so no data in the tables. I'm thinking that maybe when the website gets published a copy of the DB is moved somewhere and I'm looking in the wrong place? This is the first time I have made a webpage or used FrontPage so please excuse my ignorance, hehe.
Ok, so I made a registration website with FrontPage and published it. The registration page has several text boxes and a submit button. I was testing it out and entered a few dummy names. The conformation page popped up and said everything was ok. So I'm assuming the data successfully uploaded into the access DB that I linked it to while in development.
My problem is when I go to the folder where the DB resides there so no data in the tables. I'm thinking that maybe when the website gets published a copy of the DB is moved somewhere and I'm looking in the wrong place? This is the first time I have made a webpage or used FrontPage so please excuse my ignorance, hehe.