Search results

Some are big, some small. But I've always made a habit of copying them locally because I've found a big improvement in forms loading when several people are connected.

I have an application which contains several reference tables. I've set it up where when the user opens the application all the reference tables are copied over so that they're local. I've been doing this using make-table queries and then creating an index on them. What I'm wondering is...

Hey Pat! Was hoping this thread would catch your eye. And thanks for your input. I had the same thoughts when it came to VB as you in that it would be too much for my little experience. Reason I mentioned SQL server on the backend is that I read the Office developer program has a run-time...

Well the reason I was asking is that a friend of mine said that I would probably have less errors happen if I designed the application totally in VB. I've never used VB so I didn't know if this was true. Basically, I'm trying to find the best way to set it up. Using VB, Access on the frontend...

I have a procedure setup in one of my dbs that will send an email automatically for someone on a certain event. But recently I found out that for some people a warning pops up for them saying a program is trying to send an email on your behalf, do you want to prevent this? Is there anyway to...

Try this on the textbox's beforeupdate Format([Textbox],"0000")

I am making plans to develop an application to sell commercially. I wanted to get people's thoughts on what would be better to use for this purpose. Access or VB.

Is it possible to perform D expressions on recordsets in memory or something equivalent to that?

Has this happened to anyone else? I have a table in a database that has about 10 records. In a sub I setup I create a recordset and set it to this table. What I want to do is save the number of records in a variable. When I use rst.RecordCount I get 1. But I know there's more. How's this...

You're thinking is correct. The string values need to be handled differently as do date values too. string values must be contained in single quotes. Dates must be contained in the # sign. So this is what the line should look like for the string value: If Not IsNull(DLookup("BarcodeNo"...

You'll need to replace Control with the actual name of the control (textbox, combobox, etc.)

I would create a public function to use as the value of the field Public Function fValue(lngOne As Long, lngTwo As Long) As Long Dim strComplete As String Dim strTwo as String Select Case len(lngTwo) Case 1 strTwo="000" & lngTwo Case 2 strTwo="00" & lngTwo Case 3 strTwo="0" & lngTwo...

I would setup an event in the control's BeforeUpdate event to check if the value already exists in the table. If it does you can cancel the update and give a custom message to the user. Example: If Not IsNull(DLookUp("Field","Table","Field=" & Me!Control)) Then Cancel = True MsgBox "This...

I have a small database that has about half a dozen people connected to it at any given time. In the last couple of days it's been getting corrupted at least 3-4 times a day. I can't figure out why. Can anyone give me some tips on certain things I should look for that might be causing this?

Thanks. That was a good idea.

I have a report setup with a group footer. In the group footer I have a textbox that is suppose to display the sum of the records in the group that meet one criteria minus the sum of the records in the group that meet another criteria. Haven't figured this out yet. I've looked up things like...

I figured it out. I was creating some code to create an excel workbook. I guess a compilation error in that code made it so that I couldn't compile it. Once I fixed that error it corrected the problem.

What's it mean when the option to compile your code is grayed out?

I've found the problem to exist on the table level. When I try to change the number in the field and then move to another record it gives me the error: 'The Search Key was not found in any record.' First time I've ever seen that one before.

I've created a small application for about 5 users. This morning we've been finding something strange going on. All the records in the table have a field that contains a user's windows id. So when they open the frontend it will only show the records assigned to them. So there should be no...