Search results

"dir /s *.ac*" 😁

Please define "Doesn't work". What are you expecting and what are you seeing? Does the database cause your monitor to shoot flame out? Is it failing to elect the right lizard to office?

If you do this, you are asking for trouble the moment your spreadsheet contains a duplicate to what is in your database. Unless you have a really really good reason to do so, let Access do the work of keeping the autonumbers straight. Less work and headaches for you.

Having to do something like this, I have an app just to do the import. I link to the excel file and have a query to verify what I am importing. I link to the table and have an append query to update the table itself. Doing an append query means the autonumber primary key works as intended. You...

It sounds like your boss is a bigger issue than Access. I'm guessing they are the "Why can't you just have it done in 5 minutes?" kind. As for programming with Access, one of the hardest switches is getting use to how much Access will do for you if you use the tool the way it is structured. If...

Do a search on "Subform". Rather straight forward.

For future reference, will you also need something to stop them from doing this? Or will this be handled by having them use better names? For scope, difference is "Do we do this ONCE so we are not worried if it takes a while" VS "We need to do this often, so if it takes an hour that is a problem".

In general, the safest way to keep end users out of your back end is to use network permissions to prevent them from accessing where your data is stored. If they do not have rights to the folder, they can't see or change anything. The front end is normally not useful if you don't have the data...

Are you trying to lock your application to a specific processor or storage drive? Are you trying to make sure the program is not used after a "Lock out date"? Or are you trying to use a different approach to prevent unauthorized use of your software? There are many ways to stop unauthorized use...

Rather important, how do you want to choose "14292" instead of "14407"? XPS35 has already given an answer that will work, but make sure you understand how you need to choose your S_ID an have that logic written down. It will avoid massive headaches later when your query doesn't match to what...

One way to address this, if really needed, is to have two text fields. One for your "1." and the second for the actual text. In code, keep track of your indentation. Set the width to "Normal width - (indentation level * indentation space) then move the control to the right (indentation level *...

If you have the template, you have the template. No copy or paste. Not sure why you would think that. Benefit is per application you only have included what you need. There is no benefit to include address verification for an application that does not track addresses.

Template let you specify what data source you had for validation, then you'd pass the fields to fill. No more of a problem than a DLookup. Pass "PostalCode" and "Field(s) to fill". If more than one value was valid, returned (iirc) a list separated by CRLFs. Normally you'd have a drop down that...

Validating fields against a postal database and having relevant fields filled was something I could add a template for 30 years ago. Bonus was I could use one template and have it do the validation for any nation's postal database I had access to. From what you have described, I don't see any...

Were this me, I would move the names to a child table FIRST. That way for a given membership you can have one or more people who are associated with that membership. Then you can use this child table to drive your letters. Hate to send "Mr. and Mrs. John Smith" to John and his sister.

Three questions; 1) Why are you using a DAO recordset instead of using a query? 2) Why are you storing values you want to report on in a table? 3) Have you tried just creating a query on your data, then making a report to generate what you are looking for? For me, if I were doing the purchasing...

@GPGeorge, OP is looking for "Did we receive it within the last two minutes". If he had my Email, he'd be looking back to last decade with this code.

If InStr(1, olItem.Subject, "Crossroads", vbTextCompare) > 0 And olItem.ReceivedTime >= lastTwoMinutes Then This need to be two checks. One if is you have found the text. Second is if you've gone past two minutes. As is, this should be reading ALL subject lines. Not sure how well this will work...

I've a form that exploits this also. I use a button to manually add to a second table and I use an unbound field to hold the semester the students are going in to. I also update the existing table so I can refresh and have the record I've just moved disappear from the list the user (me) sees...

What does your proposal do that template based development environments don't offer? Does it allow some way to hook in specific code for specific requirements that are not in your general library? Looking to see if your offering more than Clarion 2.0 did when it came out.