Search results

Yeah, this one is kind of a weird situation...I am having to import the data into Access from Excel. My client downloads the Excel SS daily from a website. This SS requires many formulas to "clean up" data that are completely necessary to identify duplicates. Anyway, since the amount of...

How can i create a macro that will delete blank records but ONLY blanks from a table?

Thanks so much! My link is numeric, so no problem! Again, thank you!

I have managed to write a If statement in a macro to open another form when a checkbox is checked (for Yes) on the main form. Works like a charm...but a somewhat tarnished one...lol...in that it doesn't open to the corresponding record. Without VB code, is there a way to do this completely...

Never mind....got it. But still have another issue...try to solve myself before posting for help! Thanks!

I'm trying to write a simple macro that says if a particular field on a form is checked Yes (the default is No), then open another form based on the same record as current record. Basically, I have a real estate database that has a checkbox on the main form concerning properties. The field is...

vbaInet-- Read "The Evils of Lookup Fields in Tables". When users want a drop-down list to choose from (which may include hundreds of choices) I've only been taught to use Lookups. What is a better way? I'm getting a Data Mismatch when I try to write an expression on a form field and I do...

Would work but this particular spreadsheet is downloaded on a daily basis with new and previous info and could be 12 rows or 500 rows so a named range wouldn't really work. I'm going to try to learn VB and see if there's anything I can do there. I don't know any VB but if I'm going to continue...

I have a form that has a checkbox on it. The default is False. I need to open another form if the checkbox is checked (True). I can do that but how do I get the 2nd form to open to the specific record in the main form?

How hard is it to learn VBA? I suppose I can get one of those "Dummies Books". Up to this point I've only used Access to develop local databases, but I can see now that I need to probably learn both VBA and MySQL if I intend to continue in this field. I have been successful so far in giving...

Thanks for your response. I guess what I meant by "server level" was sort of an incongruous statement now that I realize what it says. I just meant could the database be set up on the server so that users accessing it could only access the parts they have rights to via a switchboard.

I can import the excel spreadsheet into the Access table using the External Data tab in Access. I'm trying to find a way to automate the process for my client. In other words, when I use the External Data import, the user still has to go through browsing to the correct Excel workbook, choosing...

I am currently developing an Access database for a client. Clients wants different switchboards for different users. This would also mean that each different user would have different rights and their personal switchboard, of course, would allow access only to the parts they have rights to...

nanscombe and jdraw - thanks to both of you for great suggestions!! As far as importing directly into Access rather than Excel, I was going to suggest that to my client. They have only been using Excel up until now (well, up until I get the DB build finished).

Thanks for your response. This one is a doozy! I have just learned from my client that he actually retrieves his data from three different sources and imports into Excel spreadsheets. He wants all this data merged into one SS that can be appended daily to an Access table. Each data set, while...

#pulllingmyhairout# I have a client for which I am developing a database in Access 2010. The data for the DB will be imported in from an Excel spreadsheet. This spreadsheet is created by my client based on information HE imports from several different organizations, appending data into one...

Thanks anyway Paul. I do appreciate the response. I figured this one out finally...I just attached a macro to the field and it worked perfectly.

Hi, I am strictly an Access user and do not know SQL or VB or anything, so everything I do has to be done through Access. I don't know if this is possible, but I would think it would be. I need to open a form based on the entry in a form field in another form. In other words, basically...I...

I have a real estate client who wants me to develop an Access database to manage all his real estate and client data. He wants to be able to share this database with his agents. What is the easiest, cheapest, most reliable way to share an Access database? I don't know how to use any other...

I have a Mac client who owns a magazine. He wants a database to keep up with Subscribers, Advertisers and Contributors. No problem there. I already have another Access database that will give him what he wants with minimal tweaking. However, I'm Windows, he's Mac, and he's got a limited...