Search results

Mary, Although the project you have described will present you with several challenges, it can be done. In fact, having an Access Application that provides users with the ability to add and/or edit live data from their desktop, a laptop, a tablet and even from their smart phone is becoming...

Here is a function that will return just the alpha characters in the string provided to it: Public Function GetTextOnly(sLoginName) As String Dim varFirstNumLoc, cntr For cntr = 1 To Len(sLoginName) If IsNumeric(Mid(sLoginName, cntr, 1)) Then varFirstNumLoc = cntr...

One way to accomplish what you want is: First, I am assuming that you have a table that is designed at a minimum to have an AutoNumber field for record ID, a date field, a ward field and a patient count field. When the encoder is ready to enter the patient count for each ward, have VBA code...

There will need to be a record in the junction table for each link you need between the two tables. The only way to have the relationship between the two tables is with a record in the junction table. You will also need to use the junction table when querying your data.

You can use VBA to check each check box to see if it is checked and if so create the sql statement by concatenating each of the field names (identified by each check box) into a correctly formed sql statement. Then use the QueryDef method to assign your sql statement created in your VBA code to...

If I understand you correctly, you have the front-end file on the server and are attempting to run your application from the server and the back-end file is also on the server. The whole concept with splitting the database is to have the back-end on a shared drive or location like a server, but...

Ok. Try this code: if not IsNull(me.step5) or me.step5 <> "" then Me.step5 = "1" & "- " & me.step5 end if I have included the "Not Is Null" and the not null string (<> "") so it will trap either of the possible values. Hope this helps.

Try this untested code: if Me.[step5] <> "1- XX" then Me.[step5] = "1" & "- " & Me.[step5] end if This code should only perform the modification to "step5" if it does not already have the "1-XX" value.

I do not think you will find an option to check for an open report when only using a macro. However, you can create or use a user defined function (VBA code) that will do the checking. You can then call the function using a macro. Take a look at this link...

Take a look at this link: http://www.peterssoftware.com/ss.htm I have used it multiple times and it has worked for me.

Have you seen this from Allen Browne? http://allenbrowne.com/ser-43.html

I hate to be the one to break the bad news to you but if you do not want the Access ribbon menu available to your users, you are going to have to create your own custom menu or menus. You do not have to assign your custom menus to the entire application. You can assign a custom menu to each...

Well, I do not know what happened but here is the file that does have the changes.

This problem occurs when you do not use fully qualified instances of the various Excel objects. Take a look at this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=248066&highlight=code+leaving+instance+of+excel+open There is a link in that thread to this...

First, by all means, if you are going to have multiple users using your database, you must split it. The back-end file must be located on a shared network drive where all users have read/write capability. Next, each user must have a copy of the front-end file located in a folder on their own...

Here are a couple of links that might get you some info: http://www.indoition.com/online-help-authoring-tool-choosing.htm http://www.thefreecountry.com/programming/helpauthoring.shtml Hope this helps.

Basically I have made some changes to the controls on your form. I replaced your embedded query with a list box named "lstDonations" and then used your query as the record source for this new list box. I renamed your combo to "cboBatchDate" and made it to only have one column (the batch date...

I am somewhat confused as to exactly what you are attempting to do. From what I am understanding , you have a form that is open to a record and you are then attempting to run a query that will update that same record. If this is the case then that would explain why you would be getting the...

Is your form is linked to the same record that you are trying to update? If so, that would be where you are getting your error.

I would take an even more definitive position than namliam has taken. In all circumstances you should split your database. There are many reasons for this but the primary one is the one that you already understand. The only way to easily allow users to maintain there data and still be able to...