Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 41
Search took 0.01 seconds.
Search: Posts Made By: Pavczech
Forum: Forms 02-06-2015, 11:53 PM
Replies: 0
Views: 775
Posted By Pavczech
Combo box filtering

Hello

I have a web database. There are couple of tables with lookup fields ( first one called department where all department codes are stored and the second one where there is a look up field...
Forum: General 06-01-2013, 11:47 PM
Replies: 0
Views: 621
Posted By Pavczech
QR Code scanner

Hi guys

Any help with this one? I would like create web based inventory database with QR Code.

Database is not the problem but, I would like to scan the code and it would bring up the item. How...
Forum: Modules & VBA 12-14-2012, 01:46 AM
Replies: 7
Views: 3,903
Posted By Pavczech
Re: Close form on Idle

Hi ya.
Yep I alredy have on the form beforeupdate code which checks if the record exist.
If it does than it cancel the input in to the table and opens another form, if the record doesn't exist it...
Forum: Modules & VBA 12-12-2012, 01:51 AM
Replies: 7
Views: 3,903
Posted By Pavczech
Re: Close form on Idle

Hello

It works as far as setting the idle time, but i have tried to close the form without updating the tables and it is not working.
I tried:
Sub IdleTimeDetected(ExpiredMinutes)
...
Forum: Modules & VBA 11-30-2012, 01:44 AM
Replies: 7
Views: 3,903
Posted By Pavczech
Re: Close form on Idle

It does what I wanted to do, there are some other issues with my forms which are connected to the forms, hope I can figure out that one. Thanks
Forum: Modules & VBA 11-28-2012, 01:40 AM
Replies: 7
Views: 3,903
Posted By Pavczech
Close form on Idle

Hello all

Could somebody help me. I need to close the form on idle more than 2 min.
There is 5 text boxes so even if somebody inputs text in one textbox, but doesn't finish the rest of them it...
Forum: Queries 11-14-2012, 01:45 AM
Replies: 2
Views: 1,008
Posted By Pavczech
query multiple optional criteria

Hi ya

Can somebody help please.

I am trying query on multiple optional criteria. I have query where I have put criteria [Enter the First Name] or [Enter the Surname], but when I input first...
Forum: Modules & VBA 11-13-2012, 03:57 AM
Replies: 2
Views: 1,047
Posted By Pavczech
Re: Run-time error "13" Type mismatch

Hi ya

i have just putted it in quotatins and took some out it works

rs.FindFirst "[Surname] = '" & Me![Text185]&"'"


Thanks for your reply
Forum: Modules & VBA 11-13-2012, 03:40 AM
Replies: 2
Views: 1,047
Posted By Pavczech
Run-time error "13" Type mismatch

Hi to all

I have trouble with this line in my code.

rs.FindFirst "[Surname] = " & Var(Nz(Me![Text185], 0))


I think it is because it is not number but text.

Could somebody help
Forum: Modules & VBA 11-06-2012, 03:21 PM
Replies: 1
Views: 416
Posted By Pavczech
Search for button

Hi

Can you help please.

I have form where i would like to add search button, which would call for a small form with a couple of the fields and search button.

Let just say "form1" where are...
Forum: Modules & VBA 10-30-2012, 06:41 AM
Replies: 7
Views: 1,366
Posted By Pavczech
Re: If Exist Update

Don't worries I have used docmd.runsql instead thanks for the other tips anyway
Forum: Modules & VBA 10-30-2012, 05:27 AM
Replies: 7
Views: 1,366
Posted By Pavczech
Re: If Exist Update

Hi Thanks sorry I was away.

Basically what I need to do is when I click the button it would update existing record.

I not sure why but when I put the ?Dlookup... it gives me right ID but it...
Forum: Modules & VBA 10-16-2012, 01:46 PM
Replies: 7
Views: 1,366
Posted By Pavczech
Re: If Exist Update

Hi thanks, but
If i do that it give me error you can't assign value to the object.
If i take it to immediate window and take it apart
?dlookup gives me the right ID, Time () gives me the time but...
Forum: Modules & VBA 10-16-2012, 08:28 AM
Replies: 7
Views: 1,366
Posted By Pavczech
Re: If Exist Update

I have attached short version of db.

What I need to happen is when you open query2 form and input surname and Dob and click submit it will just update the "TimeOut" for that record. If nothing...
Forum: Modules & VBA 10-16-2012, 07:35 AM
Replies: 7
Views: 1,366
Posted By Pavczech
If Exist Update

Hi guys

Could anybody help. I need a code to update my tables. Basicaly I have 2 forms.
1 table with Name, Surname, DOB etc.
2 table with Date, TimeIn and TimeOut.
1 query with all details
...
Forum: Modules & VBA 10-04-2012, 03:30 AM
Replies: 1
Views: 743
Posted By Pavczech
assign ID

Hi guys

Could you help me please.

I have 2 tables with relationship.
I have 2 forms related to those tables.

I need the code which would first find the ID in table 1 and than transfer...
Forum: Modules & VBA 08-21-2012, 11:49 PM
Replies: 2
Views: 2,280
Posted By Pavczech
On-screen keyboard on subform

Hi
I have my on-screen keyboard which works fine on main form but when i put subform on it it doesn't work it said it lost the focus or object doesn't support this property or method. Here is the...
Forum: Modules & VBA 08-21-2012, 02:13 AM
Replies: 9
Views: 1,459
Posted By Pavczech
Re: DoCmd close

I have tried but when I did it it wouldn't let me input the last record.
It wouldnt accept the "monthofBirth" if that record already existed.
Forum: Modules & VBA 08-21-2012, 01:58 AM
Replies: 9
Views: 1,459
Posted By Pavczech
Re: DoCmd close

Hi I have tried the Form's beforeupdate event and it stops from recording the whole form.

Is there any way how to stop only certain records?

I have this code and I would like it to undo only...
Forum: Modules & VBA 08-20-2012, 05:33 AM
Replies: 9
Views: 1,459
Posted By Pavczech
Re: DoCmd close

Thanks very much
that was the missing bit
Forum: Modules & VBA 08-20-2012, 04:17 AM
Replies: 9
Views: 1,459
Posted By Pavczech
Re: DoCmd close

Hi
my understanding of acsaveno is to save the form but nothing to do with the data on the form.
thanks
Forum: Modules & VBA 08-20-2012, 04:01 AM
Replies: 9
Views: 1,459
Posted By Pavczech
DoCmd close

Hello

Is there code which would close the form without recording it in table or specific fields?

something like DoCmd.close acform "Form" acdontsave

Thanks
Forum: Modules & VBA 08-16-2012, 04:39 AM
Replies: 3
Views: 613
Posted By Pavczech
Re: If Exists enters data in table 2

yep CancelEvent is bit uselless there.
Quite right I don't want to duplicate the data that is why I have 2 tables.
First Visitors detail- Name, Surname, DOB etc
Second Visits details- Date, Time...
Forum: Modules & VBA 08-16-2012, 04:16 AM
Replies: 3
Views: 613
Posted By Pavczech
If Exists enters data in table 2

Hi Guys

I have code whch is working fine to the point I need to close this form.
It checks if the record exist in "Visitors Book - Personal" and if it doesn't it just enter it with the visit...
Forum: Modules & VBA 08-16-2012, 03:50 AM
Replies: 6
Views: 2,067
Posted By Pavczech
Re: Dlookup on multiple criteria

Brilliant
Thanks very much
Showing results 1 to 25 of 41

 
Forum Jump



All times are GMT -8. The time now is 11:25 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World