I searched everywhere, but I think my ignorance of correct terminology is preventing me from finding the answer I need.
I have a form that holds two cascading list boxes. I want to be able to incorporate another list box that holds a record of which selection that was made, and how many per selection. The idea is to give user a visual feedback of what they selected, and be able to modify the selection.
I tried
Let Me.IDSelection.Value = Me.CategoryID.Value And Me.Specifics.Value
but the box stayed blank.... What am I doing wrong?
Hello, Im creating a database for a charity. Im in work based learning at the minute as part of my degree course. Basically, I have my ER-D which im going to use in a few days to produce the database. Please have a look at this and criticise it!
Here it is: 17333
Well, basically, i want to know if its going to work... (anything ive missed too)
Hi, we ran into quite a serious problem the other day whilst batch printing a large number of reports from Access 2000.
For some unknown reason the print job got interrupted part way through, resulting in a large number of reports not printing at all.
Our database uses an sql fragment to set the field 'isPrinted' to true upon sending reports to the printer. This is primarily to prevent records being printed more than once.
However, if, as above, the print job doesn't successfully complete the db still, as expected, marks the record as such. This provides us with a somewhat flase account of the status of the print job.
My question is this, is there a way in vb that Access can verify the success/failure of a print job?? Are there modules or code examples available that might help us interrogate the printer and perhaps abort on error?
Hey all, So I'm pretty much done with this database project, but I've got a few minor snags... 3 actually.
1) get error when use delete button and select any option other than "yes" 2) my listbox selection does not load the record in the main subform area as it is supposed to (but I think I just don't know how to set this one up) 3) the frmAdd does not allow user to enter values into the fields for some reason, don't know what's up with that one
If anyone could take a peak, check it out, let me know if there is anything I need to fix, or more importantly, how to get those above things sorted out. It would be greatly appreciated. thanks in advance
Just wondering what the consensus is on MS Office 2007 package. I find it tasty and is quit different from the past versions. That being said, I am relearning the options and finding many new features that weren’t available in the past.
I had trouble figuring out how to 1) register a group of people for a class, 2) create a list of dates to meet for a class (which I call sessions), 3) track attendance per sessions. Having looked for templates at Microsoft, I found plenty of Excel templates, but no Access. The closest is Student Registration template, which doesn't track attendance at all. So I figured I'd make a prototype to help me understand how everything works. Since I got so much input from everyone, I figure I'd return the favor and perhap make it a sample database, especially for those who desire a spreadsheet-like data entry while maintaining a properly normalized data structure.But I would prefer that other has tested and given feedbacks on the prototype before I put this in sample database forum (if that's okay with you admins) as this is my first time and I don't want to give others bad template. So anyway, here's the prototype.Note: The database is 100% undocumented, 100% error-handling free, and 100% unsecured. Use it wisely. :)PS: The attachment will reference a extraneous library. If you are getting an error, clear the reference for MS Office 11 Web Components.PSS: I knew I forgot something: There is still unsolved problem of correcting sorting the columns in datasheet view. While the underlying query correctly sorts the recordset, it seems to be ignored entirely in datasheet. If anyone has a solution, I'm all eyes here.
Hello dear experts! Will this table structure work? - Please help! I need to be able to see if certain members have paid subscription, see if stakeholders have paid for their room bookings, etc. Will it work, does it look ok to you?
Im trying to brush up my normalisation skills and logic.
I hardly ever use SQL directly - occasionally when I need to update something, and when I need a union query, but generally I try to use stored queries with global functions for parameters, rather than form references.
The SQL examples in this forum look very complex to write, and therefore very easy to miscode.
Assuming that visual queries are available in a particular system, is there any benefit to writing SQL code directly - is it faster?
Hi, Many thanks to those who helped with my last couple of problems.
I've allmost completed my project now and am debugging.
I've found that in order to close one of my forms, which has combo boxes on it, I need to have no values selected in those combo boxes. Could someone give me the visual basic script (or any alternative meathod) for resetting the combo boxes to their default values; i.e. nothing selected in them!
I got a new job (another one, actually) and though it has absolutely nothing to do with databases, or computer work for that matter, I told my boss that I like building database apps with Access. He sparked up and said that he has a program in Visual Fox Pro, an application that's "more powerful" than access, but someone came in way back when and wrote a "program" that did some calculations to the existing DB, but the PC is dying and when it does, will take the addition with it. He said that he'd be interested in me looking into it and hopefully being able to replicate the work the prior person had done.
Has anyone worked with VFP and worked in Access with it? It doesn't seem very flexible at all and it's not very intuitive. I'm not impresses with it at all, but I have an opportunity here with my boss and would like to "get her done" so to speak.
Any help or links to good VFP tutorial sites would be greatly appreciated.
Here is something I wonder if it has already existed or been asked before, a program or an add-in feature that can compile an Access database (including forms, reports, tables...) to a stand-alone .exe application, just like Visual Basic does. The reason why I think it's doable is because in Access, we use VB codes anyway and it wouldn't need to be rocket-science for Access to do something like that or this would be an improvement for future versions.
There are plenty of advantages of going from an Access form to a stand-alone app, i.e. we wouldn't need codes to hide background and menu or status bar; we wouldn't need to disable mouse-scroll or prevent users to go back and accidentally delete past records; or we wouldn't need to worry about users seeing your terrific coding techniques and on and on.....Agree that all these can be done within Access but imagine how much time it'd save you from not doing all these things.
I have a user running office 2007, with a program called Dev_Tracker wthat uses a front end of access 2000. This program allows a user to log in their project hours. The skinny is that when they lauch the program and try to make an entry they receive this error message:
Run-time error 3075
syntax error in date in query expression tbl_timesheet.weekof=#2.4.2008# AND tbl_timesheet.user=dworden.
If the user logs into another machine it works fine so it appeare to local to the machine. I have cleaned the registry and done other tweaks but no luck.:confused: Any ideas would be helpful.
I'M NEW TO DATABASE PROGRAMMING AND HAVE LIMITED PROGRAMMING EXPERIENCE. SIMPLE EXPLANATIONS AND TERMINOLOGY ONLY PLEASE
I've been tasked with producing two database systems at work.
1) A job ledger (currently excel) 2) A stock condition survey database
Question
For future proofing:
* what coding should I be investigating (I expected to use Visual Basic, I understand this has now given way to Visual.NET?) * Should be upgrading to Access 2007? * Where the best place for sample databases of this kind? * What's an SLQ system? Should I be using this instead?
On a form with a subform, when viewed in "Form View" the form and the subform ALWAYS has this vertical bar on the left side with an triangle arrow pointing to the right.
hi... i have a form that display things in a table in access. when program the form to delete a query it deletes it but does not do rs.movenext what i want to do is the form to display the next set of data from the database. i am using dao.... please help me!!
I'm getting the following error when I try and open my database: "The visual basic for applications project in the database is corrupt". I'm pretty sure I know the answer, restore from a back up. The only problem is that the sytem admin usually backs the file up every night and he has not gotten a valid backup for the past week. If any one has any ideas, besides restore, please let me know. You would save me a lot of extra work.
There is an online form which we need to fill out for each of our inventory units. This form has several dozen fields though. We have to fill each one out for every unit that we ship (which is about a hundred a day).
But the good news is, about 25 of these 30 fields are always filled in with the same value (our name, address, city, state, zip, insurance, insurance no, carrier, carrier no, etc).
What we want is a way to fill out these fields for us automatically, and all we have to do is type in the remaining 5 fields ourselves.
My temporary solution was to create a form with 5 fields and a Submit button. Then using AppActivate "Inventory Adjustment - Microsoft Internet Explorer", we would use the SendKeys function and virtually "type" in the 5 variable values and the 25 other "hardcoded" values, using the Tab key to move in between fields.
However, we have encountered some issues using SendKeys. For one, the cursor doesn't always start in the correct place, and the fields become horribly offset and skewed. Also we notice that sometimes the cursor moves "too fast" apparently and skips pasting some of the values (an issue we tried to resolve by using "wait" commands, but it didn't help consistently enough).
Is there a better way to use Visual Basic to fill in fields in an Internet Explorer window? :(
I have basic knowledge of microsoft Access and do very little with script and coding. I also design websites and can code in HTML and have good skills in Dreamweaver etc.
If I want to create a database driven website is Visual Web Developer 2005 a good software choice??
The way I see it the software will allow me to use my design skills and database knowledge to create the data driven website without needing alot of knowledge about MYSQL and PHP etc.
I have an access Query(named newSerial) : SELECT TOP 1 (Productbase.Serialnumber+1) AS Expr1 FROM ProductBase ORDER BY (Productbase.Serialnumber+1) DESC;
I want to access this new value. Its not a key since an autonumber may be any number. When I create a new product. How do I get this value inside a form? It works fine when clicking on it. But if I use an unbound box I get 1 as result and not like 76067 which it should be. If I click the query in access it works fine and show 76067. I tried: outbox=Expr1 ' gives null 'or outbox=[newserial].[Expr1] ' which gives "Access cant find the field "|" refered to you in your expression"
What should I write? Whats the correct expression?
I am in the process of re-writing an Access system that was created with 100% macros. I need to convert the custom menus that were created with macros to vb code. I tried to convert the code to modules, but I can tell that is not the path. Does anyone have a simple example? For instance, the first custom menu is just File, Exit.
Hello, I am hoping someone might be able to help me out. I am trying to create a delete query in VB for access. I have managed to get it to run the delete query, but I would like to program in the responses to the following questions: "You are about to run a delete query that will modify data in your table. Are you sure.... Yes" "You are about to delete X row(s) from the specified table. Yes"
Here is what I have so far:
Private Sub Command32_Click() DoCmd.OpenQuery "DELETEQUERY", acViewNormal, acEdit End Sub
Trying hard to create new database. After editing VB code error message appears
"error accessing file, network connection may have been lost" tables and forms are set in one file. This has occured numerous times. If I had hair I would be pulling it out . It seems to lose the code for a form. If you delete the form it remains in the Project Browser. There seems to be a "remove icon" but it is deactivated. Any ideas...Im desperately running short of time, any help will be gratefully accepted
I am trying to find out how to integrate ms access with source safe and also the cost of source safe. The microsoft website does not give me information on the cost or even how to buy source safe. Can any one help me??
I am developing a database where I need to print various forms/reports but I need one report to go to a label printer and another to an A5 printer and another to an A4 colour printer. All I know is the "DoCmd.PrintOut" method but I don't know how to specify which device ?
I am not new to Access, however I am just starting to get to the point where I need visual basic to complete some things I want to try. My question is, how do I code a button (or modify an existing one) in my form that will email the same output I get when I use a Print Report button. Here is what I have from my standard buttons:
Private Sub Save_Svc_Record_Click() On Error GoTo Err_Save_Svc_Record_Click
