Search results

Try this out..... http://www.access-programmers.co.uk/forums/showthread.php?t=181273&highlight=image It was designed for photos, but shouldn't be that much trouble to convert to movies. At least give you something to build on.

Well, this whole web apps with MS Access is starting to look like a "NOT so bright idea" Why in the world would they spend so much effort to tie a software, Access, made for small to mid size businesses, to other software that only large organizations will use? Also considering most would change...

I have been doing some searching on the upcoming release of Access 2010, with web apps in mind. What I have found is alot of sidestepping on actually explaining what the total cost would be to take on such a project. I tend to be a little lost not knowing ANYTHING about sharepoint. So a question...

Would be easier if you could see it....but, at this point I would move your calculation to the query... example... Field1: ([filedA]+[fieldB]) Then run your query with the form being open... see if any errors appear.

Your set up doesn't seem right... Your main form is an order, your subform is the detail of that order... So you should have a one to many relationship there... If there is some detail on items in the subform you wish to display on a double click I would open another form...or another subform...

Try this....... If Me.cboGeneratorNumber.column(0) = " " Or IsNull(Me.cboGeneratorNumber.column(0)) on the beforeupdate event and the form onCurrent Or just try the "IsNull(Me.cboGeneratorNumber.column(0)"

A combo? Did you try "If Me.cboGeneratorNumber.column(0) = 0 Or IsNull(Me.cboGeneratorNumber.column(0))

It sounds like your textboxes are unbound. Are they? If so, whatever you do on the form is not going to be recorded in the table. Make sure your changes made on the form are reflected in the table... open it and look. Check the control source of the texbox and checkbox.

Looks like it should be working.... Check to make sure qtyorderd, qtydeliverd, and ordercomplete are actually the names of the textboxes and checkbox... No spaces in there? And post what the error message says if you are getting one.

OK, I'm trying to work with an app in runtime 2007. I've figured out most of the errors but....... This is a split DB, backend mdb, frontend needs to be accdb, or any 07 version. Frontend will be using runtime. Link to "Linked table manager" not accessible from runtime. How can I add coding to...

Another edit, and another problem. I was looking around the net and found that not having error handling might cause a problem.... added it to all.. So we'll see. Second problem. This is a split DB, I add the link to table manager...BUT, when opened in Runtime it is greyed out...:confused:

No they are not complied. One is in mdb then another....same db just converted to accdb. So by your reply...would converting to accde make a difference? This is really my first experience at using the runtime version. Would love to get em to work.... Or its rather useless. Tried converting to...

I'm trying to use a few 07 apps at work and having some problems while testing. I loaded the 2007 runtime on my machine, it currently has 2003. I started one app and it was shutting down due to runtime error. Well, it seems to be a very generic error statement, so it doesn't give you a clue as...

Good to know. Thanks for the info Bob. I'll proceed then :)

Well, Title pretty much says it... I need to do an upgrade to a mbd frontend to add the "send email in pdf option" (Yes, I know it can be done in code, but too much of a hassle for this DB, I just want to flip the frontend to an accdb) So should I convert both frontend and backend to 2007...

Not sure if this is what you are looking for, but it checks to see if Outlook is running... Private Sub cmdEmailNotice_Click() Dim Cancel As Integer Dim ToList As String Dim objOutlook As Object On Error Resume Next Set objOutlook = GetObject(, "Outlook.Application") On Error GoTo 0 If Not...

Well, where to start...... First, I would build some queries. Don't base forms on tables. Second look at some of these tables. Like table for College... there is a compound primary key....When you place the primary key from one table into another table as a foreign key you do not mark it as a...

I think you should first look at your relationship structure... It's hard to believe with that many fields your tables have a 1 to 1 relationship. Usually... A subform is the "Many" side of a "one to many" relationship.

uh.....No, you didn't attach anything :o But without even looking it sounds like your subform is not linked to main form. Put into design view. Click the subform.. look at properties. Under "Link Child Field" and "Link Master Field".... anything there? Should be.

Check this out.... If not what your after..at least its interesting.. :) http://www.databasejournal.com/features/msaccess/article.php/3790286/Setting-Up-Right-Click-Menus-for-Access-2007.htm