Search results

I think the problem with your syntax error, might be the PASS variable being a string (alpha-numeric text). Change the line that is giving you this error to (adding the apostrophe's) .FindLast "PASS = '" & User2.PASS & "'"

The listbox is set to value list, and the 1st listbox contains a list of all files in a chosen directory (using the folder browser API). Then I only want to select certain files to go into a 2nd listbox (also value list). The 1st listbox (all files) is set to extended multi-select, and as I...

Well, if the reason you're seeing what you are is not because of the end date - minutes being greater than the beginning date - minutes, then there is something else going on behind the scenes.

I had the following bit of code in a project I'm working on that worked fine, until another user in these forumns asked about removing items from a listbox, then I modified my form to do this, and it only removes the first item selected. basically, I have 2 list boxes. The first has an...

Basically, if you have a list box that has 1 column, and multiple values like; Red Blue Green you can use RemoveListItem to take out whatever was clicked Me.ListBox.RemoveListItem("Blue") and using your existing code move that list item over to the other list. But it would be just as easy to...

knowing what TAFB is would help, but it appears that what you are doing is normal since you are taking the difference between 2 times 13:35 check in 14:16 check out 16-35 = -19 What you need to do is take into account when your minutes are less in the Check-out phase, eventhough the time is...

How many fields are you trying to validate? If it is just one, then you can place some code into the controls (field) Before_Update that checks for the value entered. Also, if you have multiple fields that make up a primary key, then you can trap the error that is produced when the form tries...

I don't have a lot of experience with linked/SQL back-end, but if you don't find any other solution, you may consider making your forms "unbound" and doing all the SQL work with ADO commands - it's a pain to code, but the up side is it runs faster. I will try to see if I can find something...

I would do as GolferGuy suggest, it might be possible to use vbTab as the concatenate, but I don't believe it works in SQL directly, you would have to integrate the rowsource of your dropdown list in with VBA in order to produce a vbTab in between columns - however, one other thing to watch out...

Maybe golfer (Vic) can confirm a yes or no on this, but it might be possible to speed up the refresh if you make a variable that is public in the month form and you can use that as your point of reference, instead of each control calling the previous control and iterating through (like day2 =...

you mention having tried different ways to reference the User2 variable when the form is closed - which is why I recommended hiding the form. When you close out of the form, any variables declared in that form (even if they are public) won't be available. The only way is to either keep the...

What you would most likely want to do is re-design your query so that the WHERE criteria is referencing the forms controls you want (i.e. Forms!Reports!EndingDate ) You can do this in a query itself, so long as the form is actually open and contains data - if you are using a click_event for a...

You are mis-using the docmd.transfertext For help with this command, highlight it in your VBA code and press F1 - should jump to the right help topic. using the TransferText as husky suggests is good if you are going to take your existing data in place it into a brand new file. However, if you...

I keep wondering why you are storing the password in the log-in/out tracking, but be that as it may. Try placing a breakpoint in your code (on the last line, End With) With User2 <== this is working .ID = UserID.Value .PASS = PASS4 End With and tthen see if PASS4 is filling the Users.PASS...

The only thing I would change is; Table: Student StuID - prime key (autonumber unless you have a better key) Firstname Lastname Midname AddrLine1 AddrLine2 City State Zip Sibling - Foreign Key (look-up) to StuID There is however, one problem with this scenario. You would have to enter a...

What type of security/log-in model are you using? Is it Access MDW or standard network log-in ID? or some home-grown system you designed with VBA? If either of the 1st two, then you can grab the userID by calling either of two variables, depending on which system you are using. Otherwise, you...

While you are in form design mode (open an existing form in Edit/Design mode, or create a new form), goto the View menu then Toolbars, then Toolbox (make sure there is not already a check mark next to Toolbox, if so, then skip this step, you already have the right toolbar opened). You should...

If I am understanding correctly (Which I admit, I may not be), you probably do not need 2 different recordsets. You may simply just need to join 3 tables together in a query instead of the current 2 (tutor and students). What I will sometimes do, when I come across a VBA line of code that uses...

I had to double-check your dbSeeChanges argument. It looks like you have it in the wrong place. Just using the commas alone, nowadays when there are other methods available, can make life a bit hectic. I would mkae dbSeeChanges say Options:=dbSeeChanges. Since you aren't using named...

not sure what you mean by "VLC". There are media player "controls" that you can drop onto a form, and there are multiple methods of playing songs - how you want those integrated into your Access application will determine the best way to do this. Also, we would need to know why file types you...