Search results

1.) Whats the best way to use a 'BLANK' form for inserting multiple records? Try changing the default view property of the bound form to 'continuous view' (Form Properties>Format>Default View). This allows multiple records to be entered/visible If you only wish to have the form be used for...

Hmm. Turns out he's right. This is a built-in function (http://msdn.microsoft.com/en-us/library/bb237783(office.12).aspx) Can't say I'd heard of it before. It's not on the list of functions I keep handy (http://www.techonthenet.com/access/functions/index.php) I'll leave it to others to respond...

Have you used the Debug options in vba to step through the code and see what is going wrong? To do this, open the vba code window to the code you want to check. Left-click on the gray border to the left of the code itself (try doing this at the line stDocName = "MyReport"). A brown dot should...

What HiTech Coach is asking for is a copy of the code in the function BuildCriteria() so that he can assess what the problem with that function is that is resulting in the error. Likely, it is not delimiting the input data in a way that avoids the string 'Rnd' being interpreted as the vba...

The general arrangement of an if statement is... if <condition test> ....code to execute if condition test is true Else ....code to execute if condition test is false end if As written, your if statement returns the current year if the month is greater than 6 or, if the current month is less...

How large is this file? You can post attachments of up to 1MB on this forum I believe....

Glad to help. Sounds like you need one table with a column to keep track of which appointment/date the row belongs to. Perhaps if you showed an example of one or two of these tables (with dummy data), along with some guidance as to what you want to do with the database, you might get some more...

Jason, I sympathise with your situation. I'm a biologist and was educated and trained at college with data storage and display via Excel. I'm really good at Excel. And that, unfortunately, taught me a lot of ways of doing things that are exactly the wrong way to store data in a relational...

I think what you want is to change the record source property of your form. I am assuming, of course, that all the relevant fields etc are in the 'new' table. And if so, and you have two tables with the same field names etc in the one database, then I strongly advise you to read up on the...

Yes. As I mentioned, you can do this using a calculated field in your make table query. For example, to calculate the latitude in DD from DMS you might use: Lat_DD: [Degrees] + ([Minutes]+[Seconds]/60)/60

Here is a list of reserved words that you might find helpful: http://support.microsoft.com/kb/286335

Paul is right, but in this instance I can think of one 'valid' reason for storing the result in decimal degrees. If you use ESRI ArcMap GIS software to link to your database and display the stored locations via an event layer, the source data must be in a table rather than a query. (ArcMap...

You could try something like: Function StrQuoteReplace(strValue as Variant) as String strValue = strValue & "" 'this converts any null to a zero length string 'the Instr function returns the position of the first apostrophe in the string, 'or gives a zero if absent If Instr(1,strValue,"'")...

I'm married. There is no respite from ego deflation even on weekends ;)

Only on days ending with 'day' Glad it worked for you. :)

or use a criteria expression along the lines of: Like IIF(Forms!Formname!textboxname = 'misc','*',Forms!Formname!textboxname) You should also trap for nulls in case the value in the textbox is empty

How about creating a query of the data that includes a calculated field which generates a random number between 0 and 100 (lookup the Rnd function). Then use a criterion of <=10 on that field. On average, this should return 10% of the rows. However, each time you run it the actual % might vary...

The way I approach this is to save all the image files within a subfolder that is located in the root folder where the database itself is located. Then, I store the relative path to the file. Whenever I need to retrieve the full path to the file I simply concatenate the path to the database...

It depends. If a company can only ever be one of the three categories then you'd have one field that stored a foreign key from the Categories table. If a company can be assigned one or more of thos categories then the correct method is to create an intermediate table between your main table...

try using something like Me.Dirty = False ... in your button's on_click event before the rest of your code runs. That forces the current record to save the data to the table. Ordinarily, the data in your form is saved to tables whenever you change records, or the form loses focus.