Search results

Do you have any documentation at all? I'm not questioning what your saying but I was curious if I could get some black and white on what to use. Also I am after a general concensus on how people view this perticular issue. Anyone Else? Thanks again.

I would like to get opinions on table design itself. Wether its best to use a unique id generated by the user ( ie. username serialnumber) etc.. or to use a system generated number? I am currious as to the pros and cons of both systems. Also the benefit of keeping an ID as far as space and...

theres a function called formatdatetime that you might be interested in. You can find out info in help but its relitively straight forward let me know if you still need help.

I realise that.. I did not design this but im going forward with it as it stands, we found that if we deleted and recreated the troublsome buttons they would fix themselves however I am not sure if this is a perminant fix.

Have any of you had problems with the display when property on forms ? I have a form that prints however the print button I do not want displayed. Somtimes this works sometimes it doesnt its real flaky. Anyone know whats up?

Dont know why... I was looking for a built in function but this should work great... Thanks a bunch.

I woudl like to see if I can find a piece of code that will tell me if a module exists in a database. Such as: if findobject(Module1) = true then 'whatever end if anyone know how to do this? Thanks

Thanks so much

Hello, I am looking for a way to link to lotus notes databases. Anyone done this before? Please let me know thanks a bunch.

1. What is it saying when you try to create one? 2. Bind the combo box to a linked table on the BE. That way you just have to add to the table on the BE and wala your combobox will have the new records. 3. See number two just have the MDE update that table on a new entry. Hope this helps...

Thank you so much for your help on this... I'll try some other ideas.

The maximum length of the Where Condition argument is 256 characters. If you need to enter a more complex SQL WHERE clause longer than this, use the OpenForm method of the DoCmd object in Visual Basic instead. You can enter SQL WHERE clause statements of up to 32,768 characters in Visual Basic...

What we do is create a make table on the FE so the users can create that before the combo box form is loaded. Then the speed issue only happens once and can be loaded into the background. I have been looking for otherways around this but have not found anything that works great. The only...

in the control source of your totals text box type = [qty] + [amt] you can do all linear equations with this format. hope this helps

If the tables are linked access has this issue. Let me know... there are ways around the speed but I need to know whether or not the tables are located on a network or on your local machine.

I assumed you were doing somthing different rich has the right Idea on this I believe.

Ok here we go. I still use dao recordsets 'they run faster '. you will have to enable your references Microsoft DAO 3.6 object library. its under tools and references in the VBA editor. sub whatever_click() dim main as dao.recorset dim crit as string set main =...

Whelp you have kinda a doosie there. What I would do is make a recordset of your table finding the date ranges you need. Then sort it assending. you can run it thur a loop to find the last date entered for and perticular item and walla. However it will be quite tedious on the system. If...

I have a ticket system that lets the users set up scedules for there tickets IE one week one month.. or they can just enter in a date that the ticket needs to be recreated.. It uses all the data off the original ticket but can be changed. Is this what your after if so I can walk you thru most...

You could check for the ldb thats created when a users in the database. and if exists statement would work however you would not know if it was doing somthing.