Search results

Over the past few years I made several databases using the same borrowed code in a module, and it always worked fine. Now, using the same module again in new database I get a compile error. Public gobjRibbon As IRibbonUI Error: user-defined type not defined. I did my research and can not...

I have an application that is several years old, it needs some updates and slimming down. I want to weed out everything that is not needed. My idea is to create a new one and only import tables, form, reports etc. that are needed from the old database. But what is the best way to determine...

If you buy something for $100 and sell it for $150 you make a 50% profit. Straightforward and easy to calculate. But what if you get the item for free ($0) and sell it for a certain amount? You cannot calculate the percentage from $0, can you? I am thinking about making the buy price just...

Access 2013. Table field is set to: Number/Byte, 0 decimals. The field is used to sort records in a particular order. In the form it is set to Standard, no Decimals and no Default Value. When I create a new record and type in: 1, it makes it 10, 2 becomes 20 etc. If I delete the value and...

Sometimes extensive updates have to be made to a table using an update query or loop through a record set. In order to be able to undo changes in case of a mistake I am thinking about the following procedure: In code: 1 - Make a copy of the table 2 - Make the changes in the original 3 -...

A friend of mine needs a fairly simple database. Since he doesn't want to use Access for some reason may be Brilliant is a solution. Does anyone have some experience with this software and doesn't mind sharing it with me? Thanks. Catalina

D:\Databases\MovieDB\Images\MyMovie.jpg D:\Databases\MovieDB\Test\Images\AnotherMovie.jpg I'm trying to isolate the part in red. I played with Mid and Instr and still can't get it . All suggestions how to get it done will be appreciated. Catalina

With the database I'm working on for someone I need to link images. The way I see it there are two options: 1 Store the full path to the image (like d:\databases\movies\myfile.jpg) or: 2 Store the path relative to the backend location (\movies\myfile.jpg) Then concatenate the backend path...

Using Access 2010/Windows 7. I found this code somewhere and I made the changes necessary. (email addresses, password) When I run it I get the error: The transport failed to connect to the server. Setting the port to 587 doesn't solve it either. Any idea what I'm missing? Dim iMsg As...

I have a string (for a password) that contains 8 - 12 characters. There has to be at least one digit in it (0-9). So I have to test it in the Before Update Event of the field. Any idea how I can accomplish this? Even better would be if it could test for an uppercase as well. All suggestions...

Using Access 2010/Windows 7. On my edit form I use Tahoma Normal for the field labels, the label background is transparent. I can move to another record without a problem but when I want to add a new record with DoCmd.GoToRecord , , acNewRec the label font gets bolder. There are no...

Would anyone have a table with the names of film directors I could have? Just the name is fine, no additional info needed. It would save me a lot of time by not having to create it myself. Thanks Catalina

In Access 2010 I made a custom ribbon. The File Tab still gives users access to features that should not be available to them such as: Compact & Repair, Encrypt etc. I spent a few hours looking for a solution but found none that works. It does not seem to be possible to hide the File Tab, but...

Over the last few years I have designed several applications in Access, and they all have one thing in common: a simple but elegant user interface. For input forms I have experimented with dark background colors, light backgrounds, backgrounds with images and gradients (causing form flicker)...

I use this to count the records that have been entered today: =DCount("*","tblPeople","PE_Added = #" & Date() & "#") Now I want to count the records entered in the current week. Tried some suggestions I found here and there such as: ?DCount("*","tblPeople","[PE_Added]>=" &...

I'm trying to find a complete Bible (any free version) in Access format. I found a few links but they point to a download from Simtel, which just shut down about 2 weeks ago. Anyone here to help me out? Thanks Catalina

Elsewhere on this forum I wrote about a project offered on a freelance site. The owner responded to my initial bid, gave me some more info about the application he needed and asked for a detailed proposal. I started writing immediately and before I could finished it, the project was awarded to...

For a project I made a table containing info of all Countries and Territories. I decided to make it available here, may be you can use it for a lookup table. It has the following fields: Country Name, Official Name, ISO3166 Alpha2, ISO3166 Alpha3, ISO3166 Numeric, Currency, Currency Code...

The other day I visited Elance.com and I noticed a post by a business owner from (supposedly) New York City. He wants to hire a full time, experienced Access developer for no more than $4.50 an hour. Obviously he is looking for someone from India, Pakistan, or some other low wage country. And...

My database contains business names and addresses in separate fields (name, address, city, zip code, state, country) Now I have to build the address block for labels. If there were just US addresses it would be easy but a business can be located in any country with the problem being that...