Search results

I am curious if there is any major different between using the the two methods. DoCmd.GoToRecord , , acNewRec ... set form control values DoCmd.RunCommand acCmdSaveRecord OR Me.Recordset.AddNew ... set recordset values here (not sure of the syntax) Me.Recordset.Update In particular, I am...

Is it possible in access, to create a button that will copy a file to a new directory? Specifically, the data field in question is an access hyperlink that we can click on to open a PDF drawing of a part. I just want to copy the file the hyperlink points to, into a new directory. EX...

I am trying to split a field that typically contains a revision level and a revision date in a single entry as follows: (Rev Level) {Space} (Date: MM/DD/YY) REL 10-30-14 A 11-20-14 C 11/13/14 Note: dates use either - or / as separators. 99% of the time, there is a space between revision level...

I am not sure how to go about this. I'd like to filter a drop down by Yes/No field in the table. Table: Employee Yes/No Field: IsActive What I am trying to do is allow old jobs to show inactive employees, but only have the drop down list active employees for new entries. Is that possible...

I have form for entering jobs, which has several sub forms within tab controls. One of the sub forms, is an item entry form. This item entry form, has an obsolete check box, and a revision pending check box. What I am trying to do, is change the color of input fields based on which check box...

I am trying to create a fairly complex report that will show a full cost breakdown of making a part. I have it mostly working similar to the text below. Where I get stuck is Department and Part Cost. The Part #, Department, and Operation are "Group By". The Operation group Footer includes...

Is it possible to do a count of items (in this case jobs) per month, over the course of several years. (Months going horizontally, years going vertically). So that looking down the column(s), lets you quickly see if there is a trend in one month typically being slow -- or overloaded compared...

I am trying to find any Applicator for a given Terminal in our database. Typically, this information is in the Item Master table, however I have come across a few entries that only have the correct information in the Die table. The original query listed: Item -- the item number Drawing --...

Thou shalt not use Autonumber if the field is meant to have meaning for thy users. Can someone clarify that? I mean some examples of when/why it is wrong to use an auto-number field?.

We have a lot of older parts that have changed names over the years. Many of our hyperlinks are broken or the wrong format. Is there a way to find / report broken hyperlinks? I'm not sure if this would be a query of some kind, or VBA script module. I am just trying to figure out how to...

I inherited an unsplit DB at work. It's been running very, very slowly lately. I did a compact and repair and that helped. I have now split the database into a front end and backend. That has helped a bit as well, but I noticed the hyperlinks are broken. Our item master table had a link...

Is there as way to create an ACCDE where Access auto launches the switchboard on start up and hides/disables access to everything else? Is there a module/macro to enable/disable this mode? So I can take my development ACCDB, run the lock script, and then convert to ACCDE. Unlock again, and...

I am working on a time ticket database and am having trouble with the form / VBScript. I wanted to make a 'smart' form (my first mistake :banghead:), but I am having a lot of trouble for something that should be really simple. I've attached a zip archive including a picture of the table, and...

I'll start off by saying I am unsure if this should be in tables or queries section of the forums. In case it matters, I am using office 2007 (accdb format) for the sub database I am working on (which links to an office 2000 mdb format, for a few fields of information -- some of the id's are in...

I've been programming for a while now mostly for fun. Recently, for work, I've been asked to do more and more database work, all in access, so I figured this would be a good place to go. I keep coming here anyways, my friend Google keeps pointing me here. :D I enjoy video games, programming...