Search results

Hair, in the Subform's properties, you can select its Link Child and Link Master specifications. I highly suggest this; go ahead and start trying to get away from those Autoform wizards. Although I'm not as dogmatic as some about never using wizards of any type, I do find that the Form wizards...

After much searching, I have finally found a Module which will open a dialog box and then return the filepath of an Excel Spreadsheet that the user selected. I can then use TransferSpreadsheet to import it straight into the database. Quite a victory, but now, if this is possible, I would like...

I actually didn't know that. That's good to remember, since I typically forget to put in my "End If's" at least 80% of the time.:rolleyes:

You're getting a syntax error, right? Try: If not isnull(me![sigblockfield]) then blah blah blah

Oh, Jeez, that's all it is; just the use of the quotes. Sorry guys, thanks for the fast help (SQL's playing catch up to the rest of my VBA and I guess my brain forgot to make a Reference to single quotes).

I have a list box which is bound to a table. Column Count is 3, first column is a bound, invisible Autonum field. I have this code in order to find a record from the form's recordset. Private Sub List_Inst_ID_DblClick(Cancel As Integer) Dim rs As Object Set rs = Me.RecordsetClone...

OK, here's an odd situation: the users of this system divide their daily tasks into "Core Tasks" and "Non-core" tasks. Everything that is included in their Core Tasks don't get billed to the client and everything that is non-core does get billed. All of the Spreadsheet stuff that I'd be saving...

As always, thank you for your comments, Pat. The only problem with getting a lot of external help with this project is that this is sort of a volunteer thing; I mean, of course I'm getting paid at work, but it was my idea to do this project as I was helping my friend out one day with her daily...

I have an open question for those that have had a lot of experience with data migration back and forth from Excel and Access. I'm just getting started on a brand new project which will put data from several different spreadsheets into a custom-designed Access database. The problem is that...

And we'll all be right here when you're drowning in frustration with getting your Crosstabs together. We've all been through it and so shall you!:confused:

My db has a one-to-many relationship set up between two tables, the one being an Items table and the many being a Serial #'s table. Daily, we were sending Access-written reports out which looked great with the Sorting and Grouping levels. However, the Project Managers are stating that they...

Have you tried an outer join?

OK, got it. Maybe not quite as simple as I thought (after all, I'm really just trying to find a way to accomplish in SQL what an Autonum already does) but it works none-the-less. Thank you for your time.

I'm trying to accomplish a (seemingly) simple task. I'd like a calculated, non-stored field in a query to increment for each row in the recordset. There will be another calculated field in this row which will simply be this new incremented field-1. The idea is that I'm trying to self-join a...

I have been going round and round with this problem. If someone has answered this question/knows the answer then, please advise.

Hi all. I have a command button which, when clicked, deletes all records out of a table, appends 100's of 1000's of records from two different tables, selects records from this table based on a parameter query, and then runs a report. Everything works, but it's taking too much time with the...

To create a form and subform bound to tables using the Form Wizard, you need your data in two separate tables and to have these tables tied together with a one-to-many relationship. Write a query that captures the fields that you need out of these tables and then use the Form Wizard to create a...

Because of the size and complexity of my database, I have been asked to right a user manual in Word. All well and good, but now I have been asked to include this file within Access. After snooping around, I found a control which was designed to perform exactly this task...

OK, that works fine, but I actually now need something a little more complex: I need Txt1 to reference the previous record, but a different textbox in that record (let's say Txt2). If they don't match up, then Txt1 is vbRed, if they do, then vbBlack (txt1 and txt2 in the same record need not...

What about Docmd.SetWarnings False Have you tried that?