Hi all
I have a tab control on a form, the tab control has 5 pages.
How to have a printout of FIRS record of Page1 follows by Page2 then Page3 then .....then printout of SECOND record of Page1 follows by page2 then page3 then......
I have an Access database with user access accounts enabled so users have to log in. When the database opens, it displays a switchboard and the database window is not visible - so there's no way for users to directly access tables etc.
I know there is a workaround to this - if you hold down shift as the database loads, the database window still opens up. Is there a way that I can prevent this from happening, whilst still leaving a way for me to access that window to allow me to manage the system?
I searched the forums for this, but only ran across this (http://www.access-programmers.co.uk/forums/showthread.php?t=98554) reference to the access 97 method. Could you please let me know what the access 2003 method for disabling this close box is or provide me criteria to search the access help files?
I am trying to write a code that will run through one of my tables and copy a value from that table and then open SAP and run a search of the value, then save an excel copy of the results of the search, and repeat for each value in the table.
I am not asking for the code for the entire thing, just the code to access SAP similar to the way you open up other applications like internet explorer.
I am new to access. When I try to create a control with control wizard, it advises that it will embed a macro that will not run nor be editable in Access 2003 or prior... What do I have to do to get a control placed that CAN be run by those...? I do not know how to write code, and am really just feeling my way thru this...thus far unsuccessfully, I might add. More on that in the Forms forum...
This is just one of a billion questions I am slowly exploring.
I have a tab control on my form. In the change event of the tab control I am trying to tell it to move to the first field on each page of the tab control whenever the page no. changes:
Private Sub TabScreenAssess_Change() 'when a new page gets the focus, set the focus to the first control on that page Dim PageNo As Integer
PageNo = Me!TabScreenAssess.Value Select Case PageNo Case "0": gynFemale.SetFocus Case "1": tbPriorHx.SetFocus Case "2": suSubUseAssess.SetFocus Case "3": mhaCognitiveFunct.SetFocus End Select
End Sub
This works when I am tabbing normally through the controls. But when I click back to the first tab, it says "Access can't move the focus to the control gynFemale" (gynFemale is the first control on the first tab.) It works for the other tabs. That is when I click on another tab, the focus goes to the first field on that tab. When I enter a value in the gynFemale field (it is a combobox, with options Yes or No), sometimes it appears to save the value, then I discover that it has been saved as record #0.
Hi, I am new to access XP. Pls. can someone tell me how can a spreadsheet control on an access form be linked to a table for retrieving data onto it. I tried export/import with a .csv/txt file but can there be a better way? Thanks in advance.
I'm currently using a Form with combo boxes to select query criteria. On the same form I have a control button which opens up a Report which is based on information generated by the underlying query. This is a fairly classic way to generate Report contents, and it works just fine when something is selected in each combo box.
The problem arises when I want to leave one or more of the combo boxes blank (i.e not select anything from the drop down list), basically to broaden the query output to include all entries for that particular field in the Table. The Report will open OK but have no content.
Is there any way around this? I'm using MS Access 97. Any assistance offered is very much appreciated.
im trying to add a text box for entering a date into the table database for my form but i cannot seem to connect the control source to the text box, the name of the box/script is not appearing in the control source list. I have already made a column in my table for this box on the form but just cannot connect the two properly?
server administrators have expressed concern about my website that it is having a negative impact on the server. He said this typically occurs when a website has a memory leak (where it obtains server resources and doesn't release them) or is opening database connections and not closing them until the point where no more are available.
I'm using asp.net to control Access and open the connections. I don't know why it isn't closing them? the website is:
pedalcar.com
Any thoughts of what the problem is and what the statement I need to close the connections?
We can delete the label, and then re-'attach' it, but there seems to be no visible property that retains this information - in either the label or the control (only done the detailed comparison for text box so far.
The reason for this is to be able to export enough data to recreate an Access form in html, and I need a label value if it exists. (And for most controls, of course, it does!)
I have a text box in an ACCESS form that is blank. How should I format it so that zeros are visible until a digit is entered into that field? This column is for ovetime figures (e.g. 1.35 hours) that will be entered later.
I would greatly appreciate any suggestions and help.
Is it possible to simulate a control array in MS Access?
I’m using a restricted version of Access 2000. I can use all normal features but some Active X controls are not licensed and it will not be possible to licence them in time I have available for my project.
I have a form which has 14 combo boxes and 24 text boxes to allow user to choose shift type and enter start and end times of shift. I know in VB 6 I have used control arrays which has vastly simplified the whole code.
I have experimented with treating the text boxes as objects and trying to create a string with the first part of the name and using numbers to differentiate between the textboxes but Access does not seem to like this.
I've searched a lot and couldn't find an answer to my problem.
I want to have a field in my form that allow me to paste an image from the clipboard to, for example, a Paint field. Then, I want to save that image to a file on a specific folder in my computer via VB.
The reason for this is that I don't want to ask the user to open paint by himself and save the file, probably in the wrong location and with the wrong name.
The first approach was creating an OLE Object directly from the Insert menu and that worked partially. It allowed me to paste the image but there wasn't a way to save it to a file, neither a method for that. It was an incrusted object, and I think that is the reason for that.
Then I tried to create the object by myself via VB, with the instructions:
Dim objeto_perfil As Object Set objeto_perfil = CreateObject("Paint.Picture") 'IT STOPS HERE
And with the variation:
Dim objeto_perfil As Object Set objeto_perfil = CreateObject("Paint") 'IT STOPS HERE
And neither worked. The error message says it lacks an object.
Then I followed an example from msdn that used a bound frame (view here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acproClass_HV05187062.asp)). The code is:
visor_perfil.Class = "Paint.Picture" ' Set class name. ' Specify type of object. visor_perfil.OLETypeAllowed = acOLELinked ' Specify source file. visor_perfil.SourceDoc = "C:RealPathimage.BMP" ' Create linked object. visor_perfil.Action = acOLECreateLink 'IT STOPS HERE ' Adjust control size. visor_perfil.SizeMode = acOLESizeZoom
It stops in the action assignation, an says "error 2753 there was an error trying to communicate with the OLE server".
I google a lot and could find much of the Paint.Picture Class.
Anyone has any ideas to overcome this issue? What am I doing wrong?
I have a question about user level security / access control.For my database I have a back-end containing the tables and a front-end with forms, queries and everything. I have set up the access user level security.Dependent from the access level of my users, some front-end options will be hidden and some queries retrieve only part of the data. For example: I have a form to calculate clients' end prices. A vendor can only see prices for his own clients, not for other vendor's clients.
BUT: to make the query work, all users need access to the tables and the back-end must be stored in a public place, right? Now all vendors can just open the back-end and see all information.Maybe protect the BE with a password and store this in the queries?
On open I change the Picture property of an image control to another image. I do it 2 places. Access crashes on the first change or on the second. In about 50 % of the cases.
I have a MS Access database which has a web browser control incorporated within . I also have a get screen capture program for "excel" which works magnificent. I would like to incorporate these 2 functions into The Access . I would like to use my web browser control located in the access example to zoom into the picture of a house . Then capture that image and save it into access in the best usable format possible ...
I do not want to use AutoNumber to generate my Stock Control Number. I need to somehow automatically generate a number so that when I enter data and then make an error it does not mess up the numbering system like AutoNumber does.
I am a novice who is will to try to do what it takes to get this going properly. I cant find anything online relating to Access 2010.
I'm using a web control to display a page. I want to have a code that can copy to a field in that same form, the html source of that page that is displayed in the web control. How I can do that?