Search results

:confused:Hi, I have one color scheme I want to use all through the database I am developing. The next examples have just one color defined, to make it simpler (a dark blue, that I would call B1) If I define the color inside the sub, it's ok (see below). private sub setlabel() Dim B1 B1 = RGB...

Hi, I have a after update event that will match the written record with any exist record in a table in the field "OrgName". If it doesn't find exact match, will call a function with a "soundex" algorithm to see if there is only a misspelling or another name altogether. In the afterupdate...

Hi all, Just having an annoying problem and have no idea what it can be...:banghead: I have a log in form, where the user logs into the database. After logging in, this form is minimized not to be seen again. This form has the user credentials and user name, that give permission to different...

Hi, I've looked for this around and didn't find. Wonder if someone can answer. I've developed a database that is working fine, however, even when I have the Shift bypass key disabled, when the database is open, I can press Alt+F11 and will open all the code... so anyone can change it. How...

Hi, I'm having sporadic problems with a code to copy and rename photos. This code is supposed to loop around a directory of photos (named after a project), and then copy a new photos (from another directory) to this folder, numbering them and the logging them in a table tphotos. The first...

Hi, I’m trying to devise the best structure for a database. I have firstly a list of around 300 location (for a start), each location will be evaluated according to a list of 200 indicators. Each indicator can be Yes or No and can have several attachments and/or hyperlinks, contact and memo...

Hi, I'm trying to get a report filtered and displayed inside a navigationform, using docmd.browseto to open the report. This report's recordset is a query and has a filed named donID (the ID number of a donor) to sort several donors. I'm using a listbox "lDonFil" to choose one or many donors...

Hi, Not sure if anyone can help with this one. I'm designing a database, and currently I'm designing reports. The DB has been working completely fine, however, when loading and working with reports, has become extremely slow. And only is slow when has to open anything containing a report. The...

Hi, I did a query which parameter is written in a text box - tprj. This text box is in a form, which is in a navigation control, which is within another navigation control. How can I refer, in the query, to this text box? The navigation forms are nmain which contains nprojects. nmainsub and...

Hi guys, I'm having an anoying problem and I'm asking if anyone knows how to solve it. I this a simple code: Me.dID.value = "SELECT [tdonors].[id] FROM tdonors where [tdonors].dname = '" & Me.DName.Value & "'" Where the text box dID will be updated with the ID value from a table named...

Hi guys, I'm having an anoying problem and I'm asking if anyone knows how to solve it. I this a simple code: Me.dID.value = "SELECT [tdonors].[id] FROM tdonors where [tdonors].dname = '" & Me.DName.Value & "'" Where the text box dID will be updated with the ID value from a table named...

Can anyone tell me what's wrong with this code? ' It worked fine before, but for some unknown reason is not counting records anymore. This is to see if is there any record departing on the same date that is the text box ETD_Txt, and if so, will open a second form Everything is stored in the...

Hi, I have the an update query that should be looking for records in one field that are not equal to a txt box (txtMovID) and replace them for the value that is in the text box - updating the new MovID in the table. My criteria is: <>[Forms]![fManifest]![MovID] - 'this is to say to look for...

Hi, I don't understand much of VBA, so I don't even know if what I'm trying to do is possible... and now this smiley is the best expression of myself. :banghead: I have one main form, with a text box that will register a record in a table "tReg" with the following fields (among other)...